Chapter 7. Performing PivotTable Calculations

Change the PivotTable Summary Calculation

If you add a numeric field to the data area, Excel uses Sum as the default summary calculation. If, instead, you use a text field in the data area, Excel uses Count as the default summary calculation. If your data analysis requires a different calculation, you can configure the data field to use any one of Excel's 11 built-in summary calculations:

  • Sum — Adds the values in a numeric field.

  • Count — Displays the total number of cells in the source field.

  • Average — Calculates the mean value in a numeric field.

  • Max — Displays the largest value in a numeric field.

  • Min — Displays the smallest value in a numeric field.

  • Product — Multiplies the values in a numeric field.

Get Excel® Pivot Tables and Pivot Charts: Your visual blueprint™ for creating dynamic spreadsheets now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.