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.v25.2.dll

NuGet Package : DevExpress.Blazor.PivotTable

Declaration

csharp

[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.

| | Min |

The smallest value.

| | Max |

The largest value.

| | Average |

The average 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.

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

| | 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

Pivot Table data cells display summaries calculated against data fields. The field’s SummaryType specifies the aggregate function.

Commonly used summary types are:

Summary Type	Description
Sum
(the default type)	The sum of field values. This type applies to numeric fields only.

Avg	The average of field values. This type applies to numeric fields only.

Count	The total number of field values.
Max	The largest field value.
Min	The smallest field value.
`Other types`

razor

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

YouTube video

Implements

SummaryType