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.1.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:
| 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{7}
<DxPivotTable Data="SalesData">
<Fields>
@*...*@
<DxPivotTableField Field="@nameof(Sales.SaleInfo.Amount)"
SortOrder="@PivotTableSortOrder.Ascending"
Area="@PivotTableArea.Data"
SummaryType="@PivotTableSummaryType.Sum" />
</Fields>
</DxPivotTable>