PivotSubtotalFunctions Enum

Lists functions used to calculate subtotals for the PivotTable fields.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

[Flags]
public enum PivotSubtotalFunctions

VB.NET

<Flags>
Public Enum PivotSubtotalFunctions

Members

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.

Related API Members

The following properties accept/return PivotSubtotalFunctions values:

• PivotField.SubtotalFunctions

Remarks

To specify a summary function(s) to calculate subtotals for a particular row or column field in a PivotTable report, use the PivotField.SetSubtotal method with the appropriate PivotSubtotalFunctions enumeration value(s) passed as a parameter.

To obtain a function(s) used in calculating the field’s subtotals, use the PivotField.SubtotalFunctions property.