officefileapi-devexpress-dot-spreadsheet-34b9b1b8.md
Lists functions used to calculate subtotals for the PivotTable fields.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
[Flags]
public enum PivotSubtotalFunctions
<Flags>
Public Enum PivotSubtotalFunctions
| Name | Description |
|---|---|
None |
Specifies that subtotals for a field are not calculated.
|
| 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 PivotSubtotalFunctions values:
To specify a summary function(s) to calculate subtotals for a particular row or column field in a PivotTable report, use the PivotField.SetSubtotal method with the appropriate PivotSubtotalFunctions enumeration value(s) passed as a parameter.
To obtain a function(s) used in calculating the field’s subtotals, use the PivotField.SubtotalFunctions property.
See Also