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.
Show totals as percentages- 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.