---

MS Excel 2003: Show Totals as a Percentage of Grand Total in a pivot table

This Excel tutorial explains how to show pivot table totals as a percentage of the grand total in Excel 2003 and older versions (with screenshots and step-by-step instructions).

Question: In Microsoft Excel 2003/XP/2000/97, how do I show the Totals as a percentage of the Grand Total in a pivot table?

Answer: In this example, we are displaying the Order IDs based on the "Sum of Quantity", but we want to show the Totals based on a percentage of the Grand Total.

To do this, first select one of the Total values that you wish to display as a percentage of the Grand Total. We have clicked on cell B3.

Right click on cell B3 and select Field Settings from the popup menu.

When the PivotTable Field window appears, click on Options button.

Then select "% of total" from the "Show data as" 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.