Sort Group Rows by Summary Values

• Apr 25, 2022

The GridControl always sorts group rows by their values. If the GridControl displays group summaries, you can sort group rows by summary values. In this case, the GridControl displays the Sort By Summary item in the column header’s context menu:

Follow the steps below to sort group rows by their summary values in code:

1. Set the GridGroupSummaryItem.SortFieldName property to a field name of the grouped column.
2. Specify the GridGroupSummaryItem.SortOrder property.

The following code sample sorts group rows by summary values at application startup:

XAML

<dxg:GridControl ItemsSource="{x:Bind ViewModel.Source}" 
                 AutoGenerateColumns="False"
                 GroupSummaryDisplayMode="AlignByColumns">
    <dxg:GridControl.Columns>
        <dxg:GridTextColumn FieldName="ProductName" GroupIndex="1"/>
        <dxg:GridTextColumn FieldName="Country" GroupIndex="0"/>
        <dxg:GridTextColumn FieldName="Quantity"/>
        <dxg:GridSpinEditColumn FieldName="UnitPrice" Mask="c"/>
        <dxg:GridDateColumn FieldName="OrderDate"/>
    </dxg:GridControl.Columns>
    <dxg:GridControl.GroupSummary>
        <dxg:GridGroupSummaryItem FieldName="UnitPrice" SummaryType="Sum" 
                                  DisplayFormat="Unit Price: Sum = {0:$0.00}" 
                                  SortFieldName="Country" SortOrder="Descending"/>
        <dxg:GridGroupSummaryItem FieldName="OrderDate" SummaryType="Max" 
                                  DisplayFormat="Order Date: Max = {0:d}" 
                                  SortFieldName="ProductName" SortOrder="Descending"/>
    </dxg:GridControl.GroupSummary>
</dxg:GridControl>

The GridControl.ClearGroupSummarySorting method allows you to clear sort by summary operations applied to the GridControl.