officefileapi-devexpress-dot-spreadsheet-80b7f166.md
Lists aggregation functions to apply to data fields in a PivotTable report.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
public enum PivotDataConsolidationFunction
Public Enum PivotDataConsolidationFunction
| Name | Description |
|---|---|
Average |
The average of the values.
|
| Count |
The number of nonempty values.
|
| CountNumbers |
The number of numeric values.
|
| Max |
The largest value.
|
| Min |
The smallest value.
|
| Product |
The product of the values.
|
| StdDev |
An estimate of the standard deviation of a population, where the sample is a subset of the entire population.
|
| StdDevp |
The standard deviation of a population, where the population is all of the data to be summarized.
|
| Sum |
The sum of the values.
|
| 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.
|
The following properties accept/return PivotDataConsolidationFunction values:
See Also