Chat with us, powered by LiveChat

How to Change a Pivot Table Calcuation

How to Change a PivotTable's Calculation in Excel

Besides adjusting the layout of your PivotTable data, you can also change how a PivotTable summarizes values. For example, you might want a PivotTable to display averages instead of totals.

Change PivotTable Calculations

  1. Click any cell inside the PivotTable.
  2. Click the Analyze tab on the ribbon.
  3. Click the Active Field button on the ribbon.
  4. Click Field Settings.

    The Value Field Settings dialog box appears. From here, you can select calculation options including Sum, Count, Average, or Max, among others.

    When a field containing numeric values is added to a PivotTable, Excel automatically calculates the sum.

    Change a Pivottables Calculation
  5. Select the type of calculation you want to use.
  6. Click OK.
    Change a Pivottables Calculation

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