How to get sums of columns

[esabay]

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 Name	Amount	Count
A	**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**

[alexnajm]

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]

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

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