Excel > Excel 2007 Advanced > PivotTable and PivotCharts

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:

1. Click the list arrow on the field being used in the Value area of the PivotTable and select Value Field Settings
2. The Value Field Settings dialogue box appears.

Choose the function you wish to use to summarise your data from the list on the Summarize by tab.



3. Click Ok

The summarised data in the PivotTable changes to use the new calculation.

Specifying PivotTable data Updating a PivotTable

Guides