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
