Class AggregateTypes

Allows to display the values in the pivot table with appropriate aggregations such as sum, product, count, average, etc… The available types are, Sum - Allows to display the pivot table values with sum. Product - Allows to display the pivot table values with product. Count - Allows to display the pivot table values with count. DistinctCount - Allows to display the pivot table values with distinct count. Min - Allows to display the pivot table with minimum value. Max - Allows to display the pivot table with maximum value. Avg - Allows to display the pivot table values with average. Index - Allows to display the pivot table values with index. PopulationStDev - Allows to display the pivot table values with population standard deviation. SampleStDev - Allows to display the pivot table values with sample standard deviation. PopulationVar - Allows to display the pivot table values with population variance. SampleVar - Allows to display the pivot table values with sample variance. RunningTotals - Allows to display the pivot table values with running totals. DifferenceFrom - Allows to display the pivot table values with difference from the value of the base item in the base field. PercentageOfDifferenceFrom - Allows to display the pivot table values with percentage difference from the value of the base item in the base field. PercentageOfGrandTotal - Allows to display the pivot table values with percentage of grand total of all values. PercentageOfColumnTotal - Allows to display the pivot table values in each column with percentage of total values for the column. PercentageOfRowTotal - Allows to display the pivot table values in each row with percentage of total values for the row. PercentageOfParentTotal - Allows to display the pivot table values with percentage of total of all values based on selected field. PercentageOfParentColumnTotal - Allows to display the pivot table values with percentage of its parent total in each column. PercentageOfParentRowTotal - Allows to display the pivot table values with percentage of its parent total in each row.

Inheritance

System.Object

AggregateTypes

Namespace: Syncfusion.Blazor.PivotView

Assembly: Syncfusion.Blazor.dll

Syntax

public sealed class AggregateTypes : Enum

Fields

Avg

Avg - Allows to display the pivot table values with average.

Declaration

public const AggregateTypes Avg

Field Value

Type
AggregateTypes

Count

Count - Allows to display the pivot table values with count.

Declaration

public const AggregateTypes Count

Field Value

Type
AggregateTypes

DifferenceFrom

DifferenceFrom - Allows to display the pivot table values with difference from the value of the base item in the base field.

Declaration

public const AggregateTypes DifferenceFrom

Field Value

Type
AggregateTypes

DistinctCount

DistinctCount - Allows to display the pivot table values with distinct count.

Declaration

public const AggregateTypes DistinctCount

Field Value

Type
AggregateTypes

Index

Index - Allows to display the pivot table values with index.

Declaration

public const AggregateTypes Index

Field Value

Type
AggregateTypes

Max

Max - Allows to display the pivot table with maximum value.

Declaration

public const AggregateTypes Max

Field Value

Type
AggregateTypes

Median

Median - Allows to display the pivot table with median value.

Declaration

public const AggregateTypes Median

Field Value

Type
AggregateTypes

Min

Min - Allows to display the pivot table with minimum value.

Declaration

public const AggregateTypes Min

Field Value

Type
AggregateTypes

PercentageOfColumnTotal

PercentageOfParentColumnTotal - Allows to display the pivot table values with percentage of its parent total in each column.

Declaration

public const AggregateTypes PercentageOfColumnTotal

Field Value

Type
AggregateTypes

PercentageOfDifferenceFrom

PercentageOfDifferenceFrom - Allows to display the pivot table values with percentage difference from the value of the base item in the base field.

Declaration

public const AggregateTypes PercentageOfDifferenceFrom

Field Value

Type
AggregateTypes

PercentageOfGrandTotal

PopulationStDev - Allows to display the pivot table values with population standard deviation.

Declaration

public const AggregateTypes PercentageOfGrandTotal

Field Value

Type
AggregateTypes

PercentageOfParentColumnTotal

PercentageOfParentColumnTotal - Allows to display the pivot table values with percentage of its parent total in each column.

Declaration

public const AggregateTypes PercentageOfParentColumnTotal

Field Value

Type
AggregateTypes

PercentageOfParentRowTotal

PercentageOfParentRowTotal - Allows to display the pivot table values with percentage of its parent total in each row.

Declaration

public const AggregateTypes PercentageOfParentRowTotal

Field Value

Type
AggregateTypes

PercentageOfParentTotal

PercentageOfParentTotal - Allows to display the pivot table values with percentage of total of all values based on selected field.

Declaration

public const AggregateTypes PercentageOfParentTotal

Field Value

Type
AggregateTypes

PercentageOfRowTotal

PercentageOfRowTotal - Allows to display the pivot table values in each row with percentage of total values for the row.

Declaration

public const AggregateTypes PercentageOfRowTotal

Field Value

Type
AggregateTypes

PopulationStDev

PopulationStDev - Allows to display the pivot table values with population standard deviation.

Declaration

public const AggregateTypes PopulationStDev

Field Value

Type
AggregateTypes

PopulationVar

PopulationVar - Allows to display the pivot table values with population variance.

Declaration

public const AggregateTypes PopulationVar

Field Value

Type
AggregateTypes

Product

Product - Allows to display the pivot table values with product.

Declaration

public const AggregateTypes Product

Field Value

Type
AggregateTypes

RunningTotals

RunningTotals - Allows to display the pivot table values with running totals.

Declaration

public const AggregateTypes RunningTotals

Field Value

Type
AggregateTypes

SampleStDev

SampleStDev - Allows to display the pivot table values with sample standard deviation.

Declaration

public const AggregateTypes SampleStDev

Field Value

Type
AggregateTypes

SampleVar

SampleVar - Allows to display the pivot table values with sample variance.

Declaration

public const AggregateTypes SampleVar

Field Value

Type
AggregateTypes

Sum

Sum - Allows to display the pivot table values with sum.

Declaration

public const AggregateTypes Sum

Field Value

Type
AggregateTypes