Skip to main content
All docs
V24.2

DxPivotTableField.SummaryType Property

Specifies the type of the summary function which is calculated against the current data field values.

Namespace: DevExpress.Blazor.PivotTable

Assembly: DevExpress.Blazor.PivotTable.v24.2.dll

NuGet Package: DevExpress.Blazor.PivotTable

Declaration

[DefaultValue(PivotTableSummaryType.Sum)]
[Parameter]
public PivotTableSummaryType SummaryType { get; set; }

Property Value

Type Default Description
PivotTableSummaryType Sum

A PivotTableSummaryType enumeration value.

Available values:

Show 12 items
Name Description
Count

The number of values.

Sum

The sum of the values.

Pivot Grid - The Sum summary type

Min

The smallest value.

Max

The largest value.

Average

The average of the values.

pivot func average

StdDev

An estimate of the standard deviation of a population, where the sample is a subset of the entire population.

Pivot Grid - The StdDev summary type

StdDevp

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

Pivot Grid - The StdDevp summary type

Var

An estimate of the variance of a population, where the sample is a subset of the entire population.

Pivot Grid - The Var summary type

Varp

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

Pivot Grid - The Varp summary type

CountDistinct

The number of distinct values.

Median

The median of the values. A median is the number separating the higher half of a value range from the lower half.

Mode

The mode of the values. A mode is the value that is repeated more often than any other.

Remarks

<DxPivotTable Data="SalesData">
    <Fields>
        @*...*@
        <DxPivotTableField Field="@nameof(Sales.SaleInfo.Amount)"
                           SortOrder="@PivotTableSortOrder.Ascending"
                           Area="@PivotTableArea.Data"
                           SummaryType="@PivotTableSummaryType.Sum" />
    </Fields>
</DxPivotTable>

Refer to the DxPivotTableField class description for more information and an example.

Implements

See Also