Data Item Group Summary

[cschnu]

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

[cschnu]

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?

[crn.siva]

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.