Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

add a sum column to the table

summer0805
6 - Meteoroid

My goal was to calculate the contribution of each cell to the total sum of the column as attached. Since there is no "sum" function, I have to use the summarize tool to the get the sum of column B and then manually add a column sum with the number calculated by the tool. Then get the contribution column using formula. Is there a smarter way to do this? 

 

Please add "sum" as a function!

5 REPLIES 5
BrandonB
Alteryx
Alteryx

You are off to a good start. You use a summarize tool to get the sum total of the column, and then you use an append tool to append that value to your original dataset. 

BrandonB
Alteryx
Alteryx

append.png

Crewsan1
5 - Atom

except you only get 16 rows????

BrandonB
Alteryx
Alteryx

You just need to allow all appends in the configuration window of the tool. It does this by default to prevent people from unintentionally creating a lot more records than they intended. 

 

append.png

BrandonB
Alteryx
Alteryx

@Crewsan1 I forgot to tag you above

Labels