Summary functions available in PivotTable or PivotChart view
From Microsoft Office Access 2003
Summary functions available in PivotTable or PivotChart view
The following table lists the summary functions provided by the AutoCalc
command that you use to create total fields.
| Function | Description |
|---|---|
| Sum | Calculates the sum of the values. |
| Count | Tallies the number of values. Empty values, such as zero-length strings (strings that contain no characters), are included in the count, but null values (values that indicate missing or unknown data) are not included. |
| Min | Returns the smallest value in the field being summarized. |
| Max | Returns the largest value in the field being summarized. |
| Average | Returns the average of the values in the field being summarized. |
| Standard Deviation | Returns the standard deviation of the values in the field being summarized, assuming the values are a sample of a larger population. |
| Standard Deviation Population | Returns the standard deviation of the values in the field being summarized, assuming the values are the entire population. |
| Variance | Returns the variance of the values in the field being summarized, assuming the values are a sample of a larger population. |
| Variance Population | Returns the variance of the values in the field being summarized, assuming the values are the entire population. |
Note The summary functions available for a field depend on the type of data in the field. For example, if a field contains text, you cannot use Sum, Min, or Max, but you can use Count for that field.