I thought it was possible for a table with a Column Summary to show that summary for each of the Groupings, if there are more than one.
For example, I want to group orders first by Current Supplier and then by Product, and I want to see a Total column summary for both groups.
Is this possible?
Hi Eric,
This is a limitation of grouping, it will only add totals to one group.
The attached shows a table grouped by pets for their clips.
If you look at Millie on the first screenshot you will see the total cost of clips is £215.00.
I have then grouped into this the Shampoo, I still get £215.00 but don’t get the breakdown of £30.00, £144.00 & £41.00 for the three different shampoos used.
It would be nice if there was the option to also total by the secondary group, but not at the moment. 
I need this quite often - would be a good upgrade
