This procedure affects total fields in the PivotTable list. It has no effect on subtotals or grand totals.
- Click the title bar of the PivotTable list.
- On the PivotTable list toolbar, click Commands and Options , and then click the Report tab.
- Under Display totals as, select one of the following:
- Column headings To display total fields across the first row below the column fields or in the top row if there are no column fields.
- Row headings To display total fields down the first column to the right of the row fields or in the leftmost column if there are no row fields.
- Right-click the total field whose values you want to view as percentages, point to Show As, and then click one of the following:
- Percent of Row Total To display the values as a percentage of the total value of each row.
- Percent of Column Total To display the values as a percentage of the total value of each column.
- Percent of Parent Row Item To display the values as a percentage of the total value of the item's parent in the row axis.
- Percent of Parent Column Item To display the values as a percentage of the total value of the item's parent in the column axis.
- Percent of Grand Total To display the values as a percentage of the PivotTable list's grand total value.