Show theme settings Shopping cart Download trialFree Trial
Change Theme Settings
Change Theme Settings
Themes
 
Show All Themes
v
...v

Sort by Summary

v
Page 1 of 12 (120 items)Prev1234567101112Next
Year[Filter]
Page 1 of 12 (120 items)Prev1234567101112Next

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.


See Also:
Collapse/Expand
Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
Open CS Solution
Open VB Solution
The source code files for this demo are installed (by default) in the following directories:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\ASPxPivotGridDemos
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\VB\ASPxPivotGridDemos