The Pivot Table editor window Totals tab allows you to specify if totals are included in the pivot table, and how they are calculated.

Follow the steps below to define the totals for your pivot table;

By default, a pivot table will include totals for each summary column you have selected. If you do not wish to include totals in your pivot table, uncheck the Show Totals check box. Enter a label to be used for the total row and columns.

If you have opted to show totals, each total will by default use the same summary operation as defined for the summary column itself. You may however wish to use an alternative summary operation for the totals. For instance, the summary column may be showing the sum of the quantity ordered, but you want the total to show the average quantity ordered.

To change the summary operation used by the totals, select the summary column the total is based on, then select the summary operation you wish to apply to the totals.

If the summary column and total both use the Average summary type, you have a choice of how the average total is calculated. The two options are described below;

Average of the source data values
This option calculates the average by totalling the summary values for each row of data in the source table that make up the specific grouping, and dividing the total by the number of source data rows that make up the specific grouping.

Average of the pivot table values

This option calculates the average by totalling the average values displayed in the pivot table for the specific grouping, and dividing the total by the number of average values displayed in the pivot table for the specific grouping.