Customize a total field

Change the orientation of total fields

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

  1. In the design window, make sure the PivotTable list is activated. For instructions, see Help for your design program.
  2. Click the title bar of the PivotTable list.
  3. On the toolbar, click Commands and Options , and then click the Report tab.
  4. Under Display totals as, select one of the following:

Show totals as percentages

  1. In the design window, make sure the PivotTable list is activated. For instructions, see Help for your design program.
  2. Right-click the total field whose values you want to view as percentages, point to Show As, and then click one of the following: