Examples

• Jul 28, 2025
• 3 minutes to read

This section provides a list of examples, grouped by features, contained in this help topic.

Providing Data

• How to: Bind a PivotGrid to a Database
• How to: Bind a PivotGrid to a Database in Code
• How to: Bind a Pivot Grid to an OLAP Data Source
• How to: Bind a PivotGrid to an OLAP Cube with the OLE DB Data Provider
• How to: Bind a PivotGrid to an OLAP Cube with the ADOMD.NET Data Provider
• How to: Bind a PivotGrid to an OLAP Cube with XMLA
• How to: Display Unbound Data in a PivotGrid Control
• How to: Save the PivotGridControl Data to a File for Later Use
• How to: Bind the PivotGrid Control to ViewModel Fields and Groups

Summarization

• How to: Add Custom Totals
• How to: Calculate Multiple Custom Totals with Custom Summary Type
• How to: Create a Custom Summary to Display the Distinct Value Count

Sorting

• How to: Sort Data by Grand Totals
• How to: Sort Data by Individual Columns (Rows)
• How to: Sort Data by Individual Columns (Rows) in OLAP Mode
• How to: Sort Data in Server Mode with the Custom Sorting Algorithm
• How to: Calculate Cumulative Values in the Pivot Grid Control

Grouping

• How to: Group Fields
• How to: Group Date-Time Values
• How to: Implement Custom Group Intervals
• How to: Implement the Group Filter
• How to: Display Top N Values

Filtering

• How to: Prevent End-Users From Changing Filter Conditions
• How to: Add and Remove Items From Filter Drop-Down Lists
• How to: Sort Filter Drop-Down Items in a Custom Manner
• How to: Apply a Filter to a Field

Editing

• How to: Edit a Cell with the Cell Editing Template

Formatting

• How to: Format Cell Values
• How to: Format Cells to Show Custom Display Text
• How to: Apply Conditional Formatting to Data Cells
• How to: Customize the Grand Total Text in the FieldValueDisplayText Event

Drill-Down (Underlying Data)

• How to: Obtain Underlying Data (Drill-Down)
• How to: Use CreateDrillDownDataSource Method to Get Underlying Data

Context Menu

• How to: Customize a Context Menu for Field Values
• How to: Remove Items from the Context Menu
• How to Customize a Context Menu with the PopupMenuShowing Event
• How to Add a Context Menu Action to Display Top 5 Values in a Column or Row

Layout Features

• How to: Save and Restore Layout to/from XML
• How to: Save and Restore Layout to/from a Stream
• How to: Split Field Value Cells
• How to: Hide Specific Rows and Columns
• How to: Hide Individual Rows and Columns
• How to: Locate a Column (Row) Header By Summary Values

Export

• How to: Visualize Pivot Grid Data in the Chart Control
• How to: Customize PivotGrid Data Before Displaying in a Chart Control
• How to: Copy Data to the Clipboard

Appearance

• How to: Customize Pivot Grid Colors
• How to: Customize the Cell Template
• How to: Create the Field Value Template
• How to: Specify Custom Styles for Pivot Grid Elements
• How to: Select Cell Templates Based on Custom Logic
• How to: Customize the Cell Appearance
• How to: Override Theme Colors

Localization

• How to: Localize Pivot Grid with the Localizer

Integration

• How to: Integrate Pivot Grid and Gauge Controls