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 (summary function: A type of calculation that combines source data in a PivotTable report or a consolidation table, or when you are inserting automatic subtotals in a list or database. Examples of summary functions include Sum, Count, and Average.) 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 (source data: The list or table that's used to create a PivotTable or PivotChart report. Source data can be taken from an Excel list or range, an external database or cube, or another PivotTable report.)).

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 (calculated item: An item within a PivotTable field or PivotChart field that uses a formula you create. Calculated items can perform calculations by using the contents of other items within the same field of the PivotTable report or PivotChart report.), you can't change the subtotal summary function.

Tip

Click the report.

On the PivotTable toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, click Customize on the Tools menu, and then click the Toolbars tab.), 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 (summary function: A type of calculation that combines source data in a PivotTable report or a consolidation table, or when you are inserting automatic subtotals in a list or database. Examples of summary functions include Sum, Count, and Average.) as the subtotals for the field.

Click the report.

On the PivotTable toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, click Customize on the Tools menu, and then click the Toolbars tab.), 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 (page field: A field that's assigned to a page orientation in a PivotTable or PivotChart report. You can either display a summary of all items in a page field, or display one item at a time, which filters out the data for all other items.): click PivotTable, click Table Options, and then select or clear the Subtotal hidden page items check box.