Group Summary

• May 22, 2020

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

Displaying Group Summaries

To create a group summary item, do the following.

XAML

<dxg:GridControl.GroupSummary>
    <dxg:GridSummaryItem DisplayFormat="Max: {0:c2}" FieldName="UnitPrice"
        ShowInColumn="" SummaryType="Max" />
</dxg:GridControl.GroupSummary>

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

C#

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

Obtaining Summary Values

To obtain a group summary value displayed within a specified group row, use the GridControl.GetGroupSummaryValue method.