To select a function for the main calculation via the settings pane, follow these steps:
1.Open the Constructor tab of the pivot table settings pane.
2.In the Values area, in the Calculations field, expand the drop-down list of functions corresponding to this field.
3.Select the desired function from the drop-down list.
To select a function for the main calculation via the context menu, follow these steps:
1.Select a cell or range of cells with calculated values in the pivot table.
2.Open the context menu by right-clicking, point to the Calculations option and select desired function.