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!

sample data.xlsx

BrandonB

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.