Add new Calculated Column Pivot Table

**joeserrone** · 07-09-2009, 10:26 AM

Hello Everyone,
I'm attaching here a copy of my Pivot Table, I wanted to see if I could add a column next to each Site that will show the Percentage distribution by the Task Description. It would basically take the total volume for both days and divide it by the Grand Total of all sites and then show this in Percentage. I haven't figured out how to add this to a pivot table.

Thank you very much for your help

**romperstomper** · 07-09-2009, 10:49 AM

I don't think you can display just that column as a percentage of the total. You could do something like the attached though?

**DonkeyOte** · 07-09-2009, 10:53 AM

One possible approach would be to add the TotlVolume to the Data Field a 2nd time - set the first instance to show as % of row total, the second instance set to Sum - then set Site to Subtotal - it will subtotal each site based on the first instance of TotlVolume - ie will display as a percentage also... not ideal I grant you.

EDIT: romperstomper beat me too it - with a better layout also... and I think I misinterpreted the % you were looking for