Hi,
I need to display a summary for a group of rows as in example below:
Column A Column B
AA 10
AA 20
Total 40
BB 5
BB 10
Total 15
Can anyone let me know how can I achieve the above mentioned result.
Thanks,
Anil
Looks to me like you just need to add a summary to the band for Column B and then group by Column A. What part of this are you having trouble with?
Hi Mike,
Thanks for your reply.
Yes, I can achieve this by grouping column A and add summary to column B but when I add group by column A, it displays like a hierarchical grid. I don't want grid to be displayed like hierarchical; what I want is to display like a simple grid with summary immediately after each group.
Thanks
There's no way to do that, then... unless you want to add the summary rows into your data source and calculate the sums yourself.