Hi Friends,
I have created a solution here to calculate counts by grouping Category and included Grand total row to the result set.
I hope this helps community.
Source Data:
| NAME | STAGE | 
| ABC | 6 | 
| ABC | 7 | 
| CDE | 8 | 
| CDE | 9 | 
Expected Output:
| NAME | STAGE | 
| ABC | 2 | 
| CDE | 2 | 
| GRAND TOTAL | 4 | 
WORKFLOW:
Great add to the community! There's also an add totals tool in the Crew Macros pack. Check out the other tools included as well. See the below link to download: http://www.chaosreignswithin.com/p/macros.html
not working !!
This worked for me thank you so much
