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!

[PARESH]

Since in this data set Field name is not having space or special character but if it is like (Special Money -1) then it is not getting converted properly after crosstab. could you please suggest if my column headers like this (in excel file):

Special Money -1        Special Money 2           Special Money - IV7            Special Money

10,670.00                       23,780.00                        88,900.00                              100,789.00

23,780.00                       44,900.00                        11,200.00                                45,560.00

12,450.00                       76,907.00                        23,450.00                                66,900.00

I have also attached file for reference.

Appreciate if someone can assist.

[mceleavey]

Hi @PARESH ,

you can simply rename using the Select Tool or the Dynamic Rename tool.

You can find out more about these tools by right clicking them in the Designer and selecting "Open Example". This will open some examples of the tools being used in a workflow.

You can also read more about these tools in the Help Docs section of the community:

https://help.alteryx.com/aac/en/designer-experience/designer-cloud-tool-list/workflow-developer-tool...

https://help.alteryx.com/current/en/designer/tools/preparation/select-tool.html

I would also suggest going through the training courses provided in the Academy section:

https://community.alteryx.com/t5/Maveryx-Academy/ct-p/alteryx-academy

M.

[binuacs]

@PARESH this can b also done using the field info tool

[PARESH]

@binuacs Thank you so much, It worked.

Appreciate your support.