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


Drop Filter Fields Here

If an OLAP cube contains KPI (Key Performance Indicator) information, the ASPxPivotGrid can automatically recognize it and display it in an appropriate format. This demo displays a sample report for the Internet Revenue KPI from the Adventure Works sample cube.

Each KPI in an OLAP cube has corresponding measures for its value, goal, trend, status and weight. To bind a pivot grid's field to a KPI measure, create a DataSourceColumnBinding object and assign it to the field's DataBinding property. Use the DataSourceColumnBinding.ColumnName property to specify the measure name. If you don't know their names, call the GetOLAPKPIMeasures method.

Once you bound a field to a KPI measure, you can place it to the pivot grid's data area and use as a standard data field.

Each KPI status and trend values have associated graphics that can be specified using the PivotGridField.KPIGraphic property. Use the 'Status Graphics' and 'Trend Graphics' combo boxes to change these images.

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