PivotField.SubtotalFunctions Property
Gets the function(s) used to subtotal the PivotTable field.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v19.1.Core.dll
Declaration
PivotSubtotalFunctions SubtotalFunctions { get; }
ReadOnly Property SubtotalFunctions As PivotSubtotalFunctions
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.
|
The value returned by the SubtotalFunctions property is relevant only when the specified PivotField is an outer row or column field.
See Also