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

Top Values

v
v
Order Amount
Drop Column Fields Here
Sales Person(Descending)[Filter]
Order Amount Total*
Margaret Peacock
Janet Leverling
Nancy Davolio
Andrew Fuller
Laura Callahan
Grand Total
$232,890.85
$202,812.84
$192,107.60
$166,537.75
$126,862.29
$921,211.33
Did this demo address your needs?
If you’d like us to extend this demo further, please describe your needs below.
Thank you in advance for your cooperation.
SEND FEEDBACK

This example demonstrates the Top N Values feature of the ASPxPivotGrid control. For any column field or row field you can specify how many values should be displayed and used to calculate summaries. Thus you can only select the most significant values and ignore less important information. In this example, the ASPxPivotGrid control displays the specified number of values for the selected field. Note that the values in this field are sorted against the values in the 'Order Amount' field.


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
Multi-Use Site Controls