Dynamic sum the column total

[adarsh2608]

Hello,

i want sum the column values to bottom where it need to create column with total as per screenshot. Column header is dynamic which will changing 

[Luke_C · Accepted solution]

Hi @adarsh2608 

Transpose the data then cross-tab it and select the total row option:

[michelle_mathews]

Hi @adarsh2608 , how about something like this (attached)? 

[binuacs · Accepted solution]

@adarsh2608 Similar to @Luke_C solution I added a dynamic rename tool to replace the string 'Sum_' from the column heading

[christine_assaad]

Hi @adarsh2608 

Also if you have Crew macros, you can use Add Totals tool. See below

Cheers!