I have a simple report with the following data
Account Type
Account Desc
Balance
I am grouping by the Account Type and I would like it to summarize or subtotal the Balance for each Account Type. I have tried selecting the List Column that refers to Balance and then clicking the Data>Aggregate>Total but that gives me at total for the entire report. What do I need to do to get a column group summary in my report
Thanks,
Curtis
When I group two columns together and then do a total it subtotals the first group. Is there any way of doing this with the properties of the column objects?
Hi,
For this using group span for the Balance column.
Select list from ancestor button and browse the Grouping & Sorting property and select the Account Type from left pan and drag and drop into the groups and click ok.
Select the balance column in the properties pane assign group span property as Account Type.
It’ll show the grouped data as you like.