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
 
Search JabSto ::




Custom Search