Excel > Excel 2003 Advanced > PivotTables 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. Right click on a cell on the Data field and select Field Settings
  2. Right click a cell in the Data area

  3. The PivotTable Field dialogue box appears.
  4. Choose the function you want to use to summarise your data from Summarize by list.

    PivotTable Field dialogue box

  5. Click Ok
  6. The summarised data in the PivotTable changes to use the new calculation.

Follow us on

Facebook  Twitter  You Tube