Sort by Summary

This demo illustrates the Sorting by Summary feature that allows you to sort values of a particular column field or row field by summary values calculated against a specific data field. In this example, 'Sales Person' field values are sorted by summary values calculated against another data field. You can select this data field using the combo box at the top of the ASPxPivotGrid control. Clicking the 'Sales Person' field will reverse the current sort order.

To prohibit the end-user from sorting field values by summaries, turn off the ASPxPivotGrid OptionsCustomization.AllowSortBySummary option. To prevent end-users from sorting individual field values, disable a necessary field's Options.AllowSortBySummary option.

• Sorting by Summary