O'Reilly logo

Excel® Pivot Tables and Pivot Charts: Your visual blueprint™ for creating dynamic spreadsheets by Paul McFedries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required