Class SummaryType

Enumerates the summary types available for calculations in the Pivot control. If you use the value "Custom" in a ComputationInfo object, then you are required to explicitly set the ComputationInfo.Summary value.

Inheritance

System.Object

SummaryType

Namespace: Syncfusion.XlsIO.Implementation.PivotAnalysis

Assembly: Syncfusion.XlsIO.NET.dll

Syntax

public sealed class SummaryType : Enum

Fields

Average

Computes the average of values.

Declaration

public const SummaryType Average

Field Value

Type
SummaryType

Count

Computes the count of double or integer values.

Declaration

public const SummaryType Count

Field Value

Type
SummaryType

CountNumbers

Computes the count of integer values.

Declaration

public const SummaryType CountNumbers

Field Value

Type
SummaryType

Custom

Specifies that you are using a custom SummaryBase object to define the calculation.

Declaration

public const SummaryType Custom

Field Value

Type
SummaryType

DecimalTotalSum

Computes the sum of decimal values.

Declaration

public const SummaryType DecimalTotalSum

Field Value

Type
SummaryType

DisplayIfDiscreteValuesEqual

Displays the common value if all the values to be aggregated are the same, and displays a DisplayIfDiscreteValuesEqual if the values to be aggregated are not all the same.

Declaration

public const SummaryType DisplayIfDiscreteValuesEqual

Field Value

Type
SummaryType

DoubleAverage

Computes the simple average of double or integer values.

Declaration

public const SummaryType DoubleAverage

Field Value

Type
SummaryType

DoubleMaximum

Computes the maximum of double or integer values.

Declaration

public const SummaryType DoubleMaximum

Field Value

Type
SummaryType

DoubleMinimum

Computes the minimum of double or integer values.

Declaration

public const SummaryType DoubleMinimum

Field Value

Type
SummaryType

DoubleStandardDeviation

Computes the standard deviation of double or integer values.

Declaration

public const SummaryType DoubleStandardDeviation

Field Value

Type
SummaryType

DoubleTotalSum

Computes the sum of double or integer values.

Declaration

public const SummaryType DoubleTotalSum

Field Value

Type
SummaryType

DoubleVariance

Computes the variance of double or integer values.

Declaration

public const SummaryType DoubleVariance

Field Value

Type
SummaryType

IntTotalSum

Computes the sum of integer values.

Declaration

public const SummaryType IntTotalSum

Field Value

Type
SummaryType

Max

Computes the maximum of values.

Declaration

public const SummaryType Max

Field Value

Type
SummaryType

Min

Computes the minimum of values.

Declaration

public const SummaryType Min

Field Value

Type
SummaryType

StdDev

Computes the standard deviation of values if data set contains a sample of the population.

Declaration

public const SummaryType StdDev

Field Value

Type
SummaryType

StdDevP

Computes the standard deviation of values if data set contains a complete population.

Declaration

public const SummaryType StdDevP

Field Value

Type
SummaryType

Sum

Computes the sum of values.

Declaration

public const SummaryType Sum

Field Value

Type
SummaryType

Var

Computes the variance of values if data set contains a sample of the population.

Declaration

public const SummaryType Var

Field Value

Type
SummaryType

VarP

Computes the variance of values if data set contains a complete population.

Declaration

public const SummaryType VarP

Field Value

Type
SummaryType