PivotField.SubtotalFunctions Property
Gets the function(s) used to subtotal the PivotTable field.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v24.1.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
Property Value
| Type | Description |
|---|---|
| PivotSubtotalFunctions | The PivotSubtotalFunctions enumeration members representing one or more functions used to calculate subtotals for the current field. |
Available values:
| 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. |
Remarks
The value returned by the SubtotalFunctions property is relevant only when the specified PivotField is an outer row or column field.