Summary functions available in PivotTable and PivotChart reports

Summary functions are used in automatic subtotals, data consolidations, and PivotTable (PivotTable report: An interactive, crosstabulated Excel report that summarizes and analyzes data, such as database records, from various sources, including ones that are external to Excel.) and PivotChart reports (PivotChart report: A chart that provides interactive analysis of data, like a PivotTable report. You can change views of data, see different levels of detail, or reorganize the chart layout by dragging fields and by showing or hiding items in fields.). In PivotTable and PivotChart reports, the following summary functions are available for all types of source data (source data: The list or table that's used to create a PivotTable or PivotChart report. Source data can be taken from an Excel list or range, an external database or cube, or another PivotTable report.) except OLAP (OLAP: A database technology that has been optimized for querying and reporting, instead of processing transactions. OLAP data is organized hierarchically and stored in cubes instead of tables.).

Function Summarizes
Sum The sum of the values. This is the default function for numeric data.
Count The number of data values. The Count summary function works the same as the COUNTA worksheet function. Count is the default function for data other than numbers.
Average The average of the values.
Max The largest value.
Min The smallest value.
Product The product of the values.
Count Nums The number of data values that are numbers. The Count Nums summary function works the same as the COUNT worksheet function.
StDev An estimate of the standard deviation of a population, where the sample is a subset of the entire population.
StDevp The standard deviation of a population, where the population is all of the data to be summarized.
Var An estimate of the variance of a population, where the sample is a subset of the entire population.
Varp The variance of a population, where the population is all of the data to be summarized.
 
 
Applies to:
Excel 2003