The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

PivotSubtotalFunctions Enum

Lists functions used to calculate subtotals for the PivotTable fields.

Namespace: DevExpress.Spreadsheet

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

Declaration

[Flags]
public enum PivotSubtotalFunctions
<Flags>
Public Enum PivotSubtotalFunctions
[Flags]
public enum PivotSubtotalFunctions
<Flags>
Public Enum PivotSubtotalFunctions

Members

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

None

Specifies that subtotals for a field are not calculated.

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

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.

See Also