How to get sums of columns

Question

Hi All,

I tried to get the sum of a sum but looks like alteryx is creating new columns instead. How do I improve my workflow for the below desired output.

Client NameAmountCountA**TOTAL AMOUNT FOR CLIENT A****TOTAL COUNT OF ENTRIES FOR CLIENT A**B**TOTAL AMOUNT FOR CLIENT B****TOTAL COUNT OF ENTRIES FOR CLIENT A**Client Name**TOTAL OF ALL AMOUNTS FOR ALL CLIENTS****SUM OF ALL COUNT**

3PP SPREADSHEET FOR TESTING - Dummy Data.xlsx

3pp 04 March 2024 - Dummy Data.yxmd

alexnajm · Accepted Answer

That's because your Summarize tools add prefixes to the field names - i.e. "Sum_Sum_". I would either rename the fields so that they match and the Union tool can line them up by position, or you can "Manually Configure Fields" in the Union by itself and line up your columns.

I went ahead and just changed the configuration of your original to keep your paths in check - it looks like the dummy data didn't work off hand!

caltang · Accepted Answer

This is related and may be useful for you as well:

* https://community.alteryx.com/t5/General-Discussions/How-to-sum-a-column-and-Add-total-at-the-bottom-of-the-column/td-p/1064015
* https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Grand-Total-and-Sub-Totals/td-p/88059