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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
