-
Double-click the field.
-
Do one of the following:
Subtotal an outer row or column field Click Automatic under Subtotals. To use a different summary function or display more than one type of subtotal, click the summary function you want in the box to the right of Custom (this option is unavailable for some types of source data).
Subtotal an inner row or column field Click Custom under Subtotals, if this option is available, and then click a summary function in the box to the right.
Remove subtotals Click None under Subtotals.
Note If a field contains a calculated item, you can't change the subtotal summary function.
For outer row fields, you can display subtotals above or below their items. Double-click the field, click Layout, click Show items in outline form, and then select or clear the Display subtotals at top of group check box.
Display grand totals for the entire report
-
Click the report.
-
On the PivotTable toolbar, click PivotTable, and then click Table Options.
-
Do one of the following:
Display grand totals Select the Grand totals for columns check box, the Grand totals for rows check box, or both.
Hide grand totals Clear either or both check boxes.
Note Grand totals for a field use the same summary function as the subtotals for the field.
Calculate the totals with or without hidden items
-
Click the report.
-
On the PivotTable toolbar, click Include Hidden Items in Totals
.If this button is unavailable, your source data allows you to include or exclude hidden items in page fields: click PivotTable, click Table Options, and then select or clear the Subtotal hidden page items check box.
Note When you display or hide totals, some formatting may be lost in any PivotChart reports based on the PivotTable report.