Pivot Grid for WinForms - Display KPI Graphics
The following example shows how to display KPI graphics in the Pivot Grid bound to the Northwind database. The image below illustrates the resulting UI.
Files to Review
Example Overview
To display KPI graphics, create a Pivot Grid field and bind it to the following expression:
(Iif(Sum([{0}])<100000,-1,Iif(Sum([{0}])<150000,0,1)))", fieldExtendedPrice.ExpressionFieldName)
The field values depend on the "Extended Price" field values. If the "Extended Price" field value is less than 100000, the field value is "-1". If the "Extended Price" field value is less than 150000, the field value is "0". In other cases, the field value is "1".
Use the PivotGridFieldBase.KPIGraphic property to specify a graphic set used to visualize field values.
Documentation
Key Performance Indicators (KPIs)
More Examples
Pivot Grid for WinForms - Apply Format Rules to the Data Cells