I'm not sure if I quite got there, but maybe this can give ideas.
I think you can move [Account] to the detail shelf and then aggregate using WINDOW_SUM([cfRollOn]).
Once you've set the Table Calculation settings, you will get the total, but duplicated many times, as many
as there are accounts. Using the Index calculation, you can filter it down to just one copy.
(For the Index, I first put it on the filter shelf, then I adjust it's settings, then I filter to just "1").
The table calculation settings are quite particular. I may not have got it quite right, but below is what I used.
Please see the workbook v10.5 attached in the Forum Thread:
287040roll.twbx 59.2 KB
Thank you swaroop.gantela. This is exactly the solution to the lower level MoM calc that I was looking for.
I replicated the idea in the actual dashboard and the calculations work.
I really appreciate your time to respond and providing the solution twbx.
Glad it worked for you.
All the best.