officefileapi-devexpress-dot-spreadsheet-dot-pivotfield-3cec55b3.md
Gets the function(s) used to subtotal the PivotTable field.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
PivotSubtotalFunctions SubtotalFunctions { get; }
ReadOnly Property SubtotalFunctions As PivotSubtotalFunctions
| Type | Description |
|---|---|
| PivotSubtotalFunctions |
The PivotSubtotalFunctions enumeration members representing one or more functions used to calculate subtotals for the current field.
|
Available values:
Show 12 items
| 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