Excel® 2007 PivotTables and PivotCharts

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.

• Count Nums — Displays the total number of numeric values in the source field.

• StdDev — Calculates the standard deviation of a population sample, which tells you how much the values in the source field vary with respect to the average.

• StdDevp — Calculates the standard deviation whenthe values in the data field represent the entire population.

• Var — Calculates the variance of a population sample, which is the square of the standard deviation.

• Varp — Calculates the variance when the values in the data field represent the entire population.

Change the PivotTable Summary Calculation

Note: This chapter uses the PivotTables.xlsm spreadsheet, available at www.wiley.com/go/2007pivottablesvb, or you can create your own sample database.

1. Click any cell in the ...