Show All

Customize a total field in PivotTable view

1. Open a datasheet or form in PivotTable view.
2. Do one or more of the following:

   Change the orientation of total fields

   This procedure affects total fields displayed in the view. It has no effect on subtotals or grand totals.

   1. On the PivotTable toolbar, click Properties , and then click the Report tab.
   2. 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

   • Click the total field whose values you want to view as percentages, click Show As on the toolbar, 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 view's grand total value.

   Include or exclude hidden data in totals

   This procedure affects all subtotals and grand totals displayed in the view.

   1. On the PivotTable toolbar, click Properties , and then click the Report tab.
   2. Under Calculate totals based on, do one of the following:
      • To include hidden data, select All items (including hidden items).
      • To exclude hidden data, select Visible items only.

   Notes

   • This setting affects data hidden by filtering row and column fields; data hidden by using filter fields is always excluded from totals.
     
     
   • When you choose to include hidden data, asterisks (*) appear next to the captions of subtotals and grand totals to note that the total values include hidden items as well as displayed items.