Total & grand total based on multiple column and do rank based on grand total on a column?

[khadijahneddy]

Hi and good day everyone, 

Does anyone know how to do total & grand total based on multiple columns ('total outstanding', 'a', 'b', 'a+b') and do rank based on grand total on the 'a+b' column?

Input:

Output:

Thank you in advance for your help!

[dbmurray · Accepted solution]

It's a tad unclear what platform you want your output in (in excel? You could do what you need with a pivot table).

However you can basically get the data you need by using summarize fields and then joining them all together then creating a rank. 

I've got a workflow below using your sample data that will get you all the fields you need. 

Screenshot: 

Good luck.

PS if this solves your problem, please select it as the chosen solution 🙂 Much appreciated.