The ASPxPivotGrid provides multiple modes to sort field values (by values, display text, summaries, etc.). In
previous versions, when using Sort by Summary mode, field values could only be sorted by the corresponding Grand Totals.
In this version, we’ve improved this sorting mode. Now you can sort row and column field values by summary columns and rows, respectively.
We’ve also improved the end-user capabilities. Now your end-users can sort field values by summary values via the
popup menu, while in previous versions, this could only be done in code.
To sort by column or row summaries, you should right-click the corresponding header. This invokes the popup menu.
Menu items correspond to pivot grid fields whose values can be sorted by this column or row. Select the required
menu item to sort field values by summaries. To cancel sorting, you should unselect the menu item or click Remove All Sorting.
To restrict an end-user to sort field values by summaries, turn off the ASPxPivotGrid’s OptionsCustomization.AllowSortBySummary
option. To prevent end-users from sorting the values of individual fields, disable the field’s Options.AllowSortBySummary option.