PivotGridCustomTotal.SummaryType Property
Gets or sets the type of the summary function used to calculate the current custom total.
Namespace: DevExpress.Xpf.PivotGrid
Assembly: DevExpress.Xpf.PivotGrid.v18.2.dll
Declaration
Property Value
Type | Description |
---|---|
FieldSummaryType | A FieldSummaryType enumeration value that specifies the summary function type. |
Available values:
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. |
Remarks
The DXPivotGrid control calculates custom totals against data fields. The type of a custom total’s summary function is determined by the SummaryType property.
For data 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.
Note
The FieldSummaryType.Custom summary type is not supported in OLAP mode.
Related GitHub Examples
The following code snippets (auto-collected from DevExpress Examples) contain references to the SummaryType property.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.