Pivot Grid for WinForms - How to Use the Other Cell's Values in the Current Cell Value Calculation

This example calculates percentage based on the Beverages row value for each column. The Pivot Grid handles the PivotGridControl.CustomCellValue event to display a calculated percentage value in the cell that belongs to the % of Beverages Sales column. The grand total values are hidden.

API in this example:

• PivotGridControl.CustomCellValue
• e.GetRowFields
• e.GetColumnFields
• e.GetFieldValue
• e.GetCellValue
• e.RowValueType
• e.Value

Files to Review

Form1.cs (VB: Form1.vb)

More Examples

• How to Display a Percent Difference from the Previous Parallel Period
• Pivot Grid for WinForms - Hide Row Totals

Does this example address your development requirements/objectives?

(you will be redirected to DevExpress.com to submit your response)