adding a sum value at the end of a column

[TonyMu]

Hello Guys, 

is there a function in Alteryx which adds a sum value to the end of each chosen column? something like autosum in excel. 

Cheers

[Emil_Kos]

Hi,

I don't have access Alteryx but you can check those two posts:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Summing-data-from-Multiple-columns-int...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/New-Total-Column-sum-of-values-across-...

In the first one, you will find also working workflow that should guide you on how to do it. 

In short, alteryx don't have straight build sum of columns functionality. 

If this was helpful please mark my post as a solution. 

[MarqueeCrew]

@TonyMu ,

 there's a CReW macro for you!  Add Totals

 you can find it http://www.chaosreignswithin.com/p/macros.html?m=1  

cheers,

 mark

[atcodedog05]

Hi @TonyMu 

Here is a generic approach.

Output:

Workflow:

Step-1: using recordID tool set up a Id column

Step-2: using transpose, only select columns that needs to be added up as data columns and rest all as key columns

Step-3: using crosstab, set the recordID and other columns (columns which was not selected as data in transpose) set name as header and value as value. And select aggregation as avg, total row, total column.

Step-4: using formula tool, to set the last row recordID as text Total

Hope this helps 🙂 Feel to ask if you have any questions

[TonyMu]

Thanks, This will make a sum value for each existing column, Is there a way to apply this to specific columns only? 

for example if I want to have a sum value on my last 2 columns only and not on 10 other columns before it

[Emil_Kos]

Hi @TonyMu,

in this case you need to use formula function and use formula similar to the one below

[column1]+[column2]

[TonyMu]

Hello Emil_Kos, 

I think you misuderstood me, sorry for not being clear 🙂 

I want to make a sum of each colmn seperately at the end of each column, what you wrote makes sum of 2 columns, thats not what I want to do. 

something like this: 

Name	time	Code	value 2	value 3	order	prio
FSIKJ	2020.12.02	X1	12	5	13	1
olkijn	2020.12.03	B5	3	7	16	3
			15	12

values 15 and 12 in table above is what I want to generate

[atcodedog05]

Hi @TonyMu 

My previous workflow could also be modified for this task.

But here is a much simple workflow for the task.

Output:

Workflow:

In the summarize tool add the column on sum. To get total for that column. And rename it same as column name.

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05]

Hi @TonyMu 

Just posted a response similar to your requirement🙂 

[atcodedog05 · Accepted solution]

Hi @TonyMu 

Here the same workflow using your data.

Input:

Output:

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions