Total Function

You can quickly add totals to your pivot table data. The new total value is created as an additional column. Total functions can be applied to:

Underlying values from the original results sections
Surface values displayed in the Pivot

Depending on which set of values you apply the total function, different results are yielded. Consider a simple pivot table with two values of 20 and 30. Each of these is already a total of underlying values (20 = 8 +12 and 30 = 10 + 20). An average of the underlying value yields the result of 12.5 = (8 + 12 + 10 + 20) /4). An average of the surface values yields the results 25 = (20 +30) / 2).

To add totals to a Pivot:

Click a row or column label handle to select it.
Selecting the outermost label creates a total; selecting an inner label creates a subtotal.
Select Add Total on the shortcut menu.
A submenu of data functions is displayed.
Select a data function.