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