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

PivotDataConsolidationFunction Enum

Lists aggregation functions to apply to data fields in a PivotTable report.

Namespace: DevExpress.Spreadsheet

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

Declaration

public enum PivotDataConsolidationFunction
Public Enum PivotDataConsolidationFunction
public enum PivotDataConsolidationFunction
Public Enum PivotDataConsolidationFunction

Members

Name Description
Average

The average of the values.

func_average

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.

func_stddev

StdDevp

The standard deviation of a population, where the population is all of the data to be summarized.

func_stddevp

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.

func_var

Varp

The variance of a population, where the population is all of the data to be summarized.

func_varp

Remarks

The PivotDataConsolidationFunction enumeration members are used by the PivotDataField.SummarizeValuesBy property.

See Also