Designer | Dynamic Grand Total

[Mj9715]

Hi All 

During the course of my workflow, I end up with summarized data looking like below. I need to Grand total column (as shown in red), which is row-wise sum of multiple numeric columns. The catch is that the number of numeric columns isnt constant, sometimes its three cols like shown below and sometimes thirty!! 

So using a manual formula like [col1] + [col2] wont work.  Attached sample data for reference. 

Can someone suggest how to create the total dynamically based on number of columns present in that run?

Group	Account Designation	2_5_years	7_10_years	_1_year	Grand Total
HK	F			87	87
HK	H	975	6500	1820	9295

[atcodedog05 · Accepted solution]

Hi @Mj9715 

You can use the transpose crosstab combo and use crosstab functionally to get column total like below. This method is dynamic.

Hope this helps : )

[Mj9715]

@atcodedog05 Quick and helpful as always!! Thank you, you are amazing!

[atcodedog05]

Happy to help : ) @Mj9715 

Cheers and have a nice day!