wpf-devexpress-dot-xpf-dot-pivotgrid-dot-pivotgridfield-baeaf5de.md
Gets or sets the type of the summary function which is calculated against the current data field. This is a dependency property.
Namespace : DevExpress.Xpf.PivotGrid
Assembly : DevExpress.Xpf.PivotGrid.v25.2.dll
NuGet Package : DevExpress.Wpf.PivotGrid
public FieldSummaryType SummaryType { get; set; }
Public Property SummaryType As FieldSummaryType
| Type | Description |
|---|---|
| FieldSummaryType |
A FieldSummaryType enumeration value that specifies the summary function type which is calculated against the current field.
|
Available values:
Show 13 items
| Name | Description |
|---|---|
| Count |
The number of values (excluding Null and DBNull 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.
| | Custom |
The calculations should be performed manually using the PivotGridControl.CustomSummary event.
| | CountDistinct | | | Median | | | Mode | |
The DXPivotGrid control calculates summaries against data fields. The summary function type is determined by the field’s SummaryType property.
For fields which don’t contain numeric data, only the following summary functions can be calculated: FieldSummaryType.Count, FieldSummaryType.Min and FieldSummaryType.Max. If the field’s SummaryType property is set to any other value, the corresponding data cells will display zeros. For numeric data, fields any summary function type listed by the FieldSummaryType enumerator can be calculated.
You can implement a custom summary function by handling the PivotGridControl.CustomSummary event.
See Also