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