PivotGridFieldBase.SummaryType Property
Gets or sets the type of the summary function which is calculated against the current data field.
Namespace: DevExpress.XtraPivotGrid
Assembly: DevExpress.PivotGrid.v19.1.Core.dll
Declaration
[DefaultValue(PivotSummaryType.Sum)]
[XtraSerializableProperty]
[XtraSerializablePropertyId(2)]
public PivotSummaryType SummaryType { get; set; }<DefaultValue(PivotSummaryType.Sum)>
<XtraSerializableProperty>
<XtraSerializablePropertyId(2)>
Public Property SummaryType As PivotSummaryTypeProperty Value
| Type | Default | Description |
|---|---|---|
| PivotSummaryType | Sum |
A PivotSummaryType enumeration value that specifies the summary function type which is calculated against the current field. |
Remarks
PivotGridControl 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: PivotSummaryType.Count, PivotSummaryType.Min and PivotSummaryType.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 PivotSummaryType enumerator can be calculated.
NOTE
The SummaryType property is not in effect in the OLAP mode. The summary type of a measure is controlled by Analysis Services itself and it is not possible to customize it using the PivotGrid control.