Group Summary

• Sep 21, 2018

A group summary represents a value of the aggregate function calculated over all data rows within a group. Group summaries are displayed within group rows, and are stored within the grid’s GridControl.GroupSummary collection.

Displaying Group Summaries

To create a group summary item at design time, use the GroupSummary Collection Editor.

XAML

<Grid:GridControl.GroupSummary>
    <Grid:GridSummaryItem DisplayFormat="{}{0:c}" FieldName="UnitPrice" SummaryType="Max" />
</Grid:GridControl.GroupSummary>

To display group summaries in code, create a new instance of the SummaryItemBase class, specify its properties and add it to the GridControl.GroupSummary collection.

C#

DevExpress.UI.Xaml.Data.GridSummaryItem groupSummaryItem = new DevExpress.UI.Xaml.Data.GridSummaryItem();
groupSummaryItem.FieldName = "UnitPrice";
groupSummaryItem.DisplayFormat = "Max: {0:c2}";
groupSummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Max;
grid.GroupSummary.Add(groupSummaryItem);

Align Group Summaries By Columns

By default, group summaries are displayed to a group row’s right. To display group summaries under corresponding columns, set the GridControl.GroupSummaryDisplayMode to GroupSummaryDisplayMode.AlignByColumns.