This example demonstrates how to add a new item to the field header's popup menu. This item shows or hides totals in the PivotGrid control.

The following example shows how to print a document that contains a Pivot Grid control with an integrated Chart.

The following example shows how to customize cells appearance in the exported document when you export the Pivot Grid to XLSX (or XLS) format.

This example calculates and displays the difference of Income and Outlay in totals.

This example demonstrates how to specify connection settings to the Adventure Works cube on the OLAP server.

This example demonstrates how to show color description for the pivot grid rows and color graph line according to the selected cells.

The following example demonstrates how to implement sorting by summary in OLAP mode.

The following example demonstrates how to split field value cells.

This example demonstrates how to display the Customization Form near the Pivot Grid.

The following example demonstrates how to add custom text to the Pivot Grid's data used as the data source for the Chart control.

This example demonstrates how to sort the Sales Person field by the hidden Last Name data field.

This example shows how to to apply a custom appearance to a set of cells, corresponding to the same field values.

This example demonstrates how handle the CustomChartDataSourceRows event to hide unnecessary series from the Chart control connected to the Pivot Grid.

The following example shows how to apply a data bar format condition (the FormatConditionRuleDataBar class) to the Pivot Grid data cells.

This example handles the CustomDrawFieldValue event to fill the header's color.

The following example demonstrates how handle the CustomFieldValueCells event to hide specific rows and columns.

This example demonstrates how to organize the Customization Form fields in folders.

This example demonstrates how to handle the CustomCellValue event to hide field's row totals and grand totals.

The following example shows how to handle the PivotGridControl.CustomCellEdit event to assign different in-place editors to different types of cells.

This example demonstrates how to clear grid lines and hide Pivot Grid elements such as text labels and the grand total column.