how to calculate percentage using pivot table excel 2007?
When the Value Field Settings window appears, click on the "show values as" tab. Then select "% of total" from the drop down list. Click on the OK button. Now when you view your pivot table, you should only see the Totals displayed as a percentage of the Grand Total.