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
Hi @TonyMu
Here the same workflow using your data.
Input:
Output:
Workflow:
Hope this helps 🙂 Feel to ask if you have any questions
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-into-a-new-calculated-column/m-p/151270/highlight/true#M27596
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/New-Total-Column-sum-of-values-across-many-columns-per-row/m-p/156723/highlight/true#M41341
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.
@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
Here is a generic approach.
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
