PivotGridCustomTotalBase.SummaryType Property

Gets or sets the type of the summary function used to calculate the current custom total.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v20.1.Core.dll

Declaration

[DefaultValue(PivotSummaryType.Sum)]
public PivotSummaryType SummaryType { get; set; }
<DefaultValue(PivotSummaryType.Sum)>
Public Property SummaryType As PivotSummaryType

Property Value

Type Default Description
PivotSummaryType

Sum

A PivotSummaryType enumeration value that specifies the summary function type.

Remarks

The XtraPivotGrid 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: 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 PivotSummaryType.Custom summary type is not supported in OLAP mode.

See Also