PivotField.SubtotalFunctions Property

Gets the function(s) used to subtotal the PivotTable field.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.1.Core.dll

Declaration

C#

PivotSubtotalFunctions SubtotalFunctions { get; }

VB.NET

ReadOnly Property SubtotalFunctions As PivotSubtotalFunctions

Property Value

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.

Remarks

The value returned by the SubtotalFunctions property is relevant only when the specified PivotField is an outer row or column field.