Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

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
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.

See Also