Changing a PivotTables Calculation
A PivotTable summarises values using the Sum function by default. However, instead of totals you may wish to know the number of orders taken, or the average amount of them orders.
To change a PivotTables calculation:
- Right click on a cell on the Data field and select Field Settings
- The PivotTable Field dialogue box appears.
- Click Ok
Choose the function you want to use to summarise your data from Summarize by list.
The summarised data in the PivotTable changes to use the new calculation.