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 |
Solved! Go to 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 : )
@atcodedog05 Quick and helpful as always!! Thank you, you are amazing!
Happy to help : ) @Mj9715
Cheers and have a nice day!