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.