PivotField.SubtotalFunctions Property
Gets the function(s) used to subtotal the PivotTable field.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v24.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
#Declaration
PivotSubtotalFunctions SubtotalFunctions { get; }
#Property Value
Type | Description |
---|---|
Pivot |
The Pivot |
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. |
Count |
The number of numeric values. |
Max | The largest value. |
Min | The smallest value. |
Product | The product of the values. |
Std |
An estimate of the standard deviation of a population, where the sample is a subset of the entire population. |
Std |
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.