For a field that is added to the Values area, you can select a function for the main calculation and a function for an additional calculation.
The functions for the main calculation use data from the source table. Aggregating functions (summary functions in Excel) are used as such functions. Aggregating functions are used in statistics and data analytics to analyze and summarize information. Such functions include, for example, the sum, average, minimum and maximum values, and the number of elements for the selected data group.
When adding a field to the Values area, the function for the main calculation is selected automatically as follows:
•If the field contains numeric data, the Sum function is selected.
•If the field contains text data, the Count function is selected.
The additional calculation functions use data from the value area of the pivot table. These functions allow to reduce time and effort when analyzing data and building reports, without the need for the third-party spreadsheet editors or manual methods for applying additional calculations.
When adding a field to the Values area, the function for additional calculation is not used by default. It can be selected manually as described below.
There are several ways to select a calculation function:
•Using the settings pane of the pivot table.
•Using the context menu of the pivot table cells.