Microsoft Office Tutorials and References

In Depth Information

**Change the PivotTable Summary Calculation**

Change the PivotTable

Summary Calculation

If your data analysis requires a calculation

other than Sum (for numeric data) or Count

(for text), you can configure the data field to

use any one of the nine other summary

calculations that are built into Excel:

●
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

when the 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.

1
Click any cell in the data

field.

1

2
Click the Options tab.

3
Click Calculations.

4
Click Summarize

Values By.

2

3

4

If you see the calculation

you want to use, click it

and skip the rest of these

steps.

5
Click More Options.

●

5