Totaling Data in a Column

Question

Hello All -

I have a set of data where I used the Transpose tool to group my data together directly followed by a Cross tab tool to align the data correctly. The Cross tab tool is where I tried to create a total column but instead of creating a total for each [User_ID] it creates a total for the entire batch of data. When writing the data into a table, I am grouping by [User_ID] and this is causing each group of records to not have a total. Please see below for current output followed by the desired output.

Alteryx Example.xlsx

CoG · Accepted Answer

You use the Summarize Tool prior to the Cross Tab Tool to achieve this goal:

Hope this helps and Happy Solving!

david_m · Accepted Answer

Same idea as some others posted, but a little different.