Chapter 9. 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

  • Count Numbers ...

Get Excel® PivotTables and PivotCharts: Your visual blueprint™ for creatingdynamic spreadsheets, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial