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!
Solved! Go to 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.