Summary Display Modes

  • 2 minutes to read


The Pivot Grid control supports summary display modes in the Legacy data processing engine. For the Optimized engine, use Window Calculation Functions instead.

Summaries in cells are calculated according to the PivotGridFieldBase.SummaryType property of data fields. By default, they are displayed “as is”.

PivotGridControl can show how these values correlate to summary values in other cells, instead of displaying raw summary results. For instance, the pivot grid allows you to display the percentage of the totals and grand totals, or the absolute or percentage difference between current and preceding cells.

A data field’s PivotGridFieldBase.SummaryDisplayType property allows you to choose one of the predefined summary display modes. By default, this property is set to PivotSummaryDisplayType.Default, indicating that summary values are displayed “as is”.

See the following topics for more information about predefined summary display modes provided by PivotGridControl:


If none of these summary display modes suits your needs, use the PivotGridControl.CustomCellValue, PivotGridControl.CustomCellDisplayText or PivotGridControl.CustomSummary events to implement custom summaries.

The following code snippet illustrates how to set the SummaryDisplayType properties to RankInRowSmallestToLargest.

using DevExpress.XtraPivotGrid;


fieldExtendedPrice1.SummaryDisplayType = PivotSummaryDisplayType.RankInColumnSmallestToLargest;
See Also