Sum of columns

[Tid14]

Hi, i am workin on a workflow, where i need to take sum of all the values in the column and total in the last row and then valued in the output should look like this:

 

How to get the total sum value in place along with Total in the first column.

 

[Luke_C]

Hi @Tid14 

One way would be to summarize all the fields to get the total, then union it back to the data set. This is a very common question - here are a few posts that might help get you in the right direction. If you post some data (i.e. not a picture) we can mock it up if any of the solutions below are unclear.

Solved: Adding total row - Alteryx Community

Solved: Add a 'Total' Row - Alteryx Community

Solved: create a TOTAL row? - Alteryx Community

[Nanoq]

You can use a Summarize tool to sum each column you want, just delete the sum_ prefix from the names.

Then you just need to use the formula tool to add a "new" column named the same as your leftmost column, and give it the value of "Total".

Use union afterwards, to get it all back together. 
See attatched workflow