As in the above image, I want to add the Grand Total row with the sum of count column corresponding to it. Right now it is just green part.
Solved! Go to Solution.
You can use the summarize tool to aggregate. In this instance you can just take an ungrouped sum to return the grand total, and then union it back onto the bottom of your data set.
Thanks, works perfectly as intended.