See solution in other versions of Excel:. Question: In Microsoft Excel 2011 for Mac, 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. On cell B3 and select Field Settings from the popup menu. When the PivotTable Field window appears, click on Options button.
![Excel Excel](/uploads/1/2/5/6/125621933/681968821.png)
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.
So as you can see, referencing Excel PivotTable Calculated Items by Position is a great way to calculate rolling averages, or rolling totals, but you must remember to maintain them or you could end up with some kooky data.