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:
