I have a requirement where I have to display subtotals and it is not working as expected.
I am creating a bucket using rank function and when trying to turn on the subtotals it is displaying the value of grand total in the first bucket only.
Attached is the sample workbook.
1 answer
Hi Ankit,
Jonathan Drummey has some great posts on subtotals and grand totals that explain what is going on better than I ever can - you can find it here https://drawingwithnumbers.artisart.org/category/grand-totals-2/
HTH
Peter
