Customize the display of subtotals

In the pivot table, you can:

•Display/hide subtotals for each data group.

•Change where subtotals are displayed if you selected Compact or Outline layout for the pivot table. In a table with the Tabular layout, subtotals are always displayed under the data group.

To hide or display subtotals, in the Subtotals section, uncheck or check the Display box.

In the Location drop-down list, select a location to display subtotals:

•Under the group: A line of Header_group Total type is displayed under each data group.

•In the group title: Subtotals are displayed in rows with data group titles.