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. Clicking the Value field list arrow
  3. The Value Field Settings dialogue box appears.
  4. Choose the function you wish to use to summarise your data from the list on the Summarize by tab.

    Value Field Settings 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