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 live online training, plus books, videos, and digital content from nearly 200 publishers.