add a sum column to the table

[summer0805]

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!

[BrandonB · Accepted solution]

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 · Accepted solution]

 

[Crewsan1]

except you only get 16 rows????

[BrandonB]

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. 

 

[BrandonB]

@Crewsan1 I forgot to tag you above