Examples

• Aug 01, 2019
• 2 min to read

This section provides a list of examples grouped by features. To get detailed information on specific features, browse the main Pivot Grid page.

Binding to Data

• How to: Create and Bind a Pivot Grid to Data in Code
• How to: Bind a Pivot Grid to an OLAP Datasource
• How to: Add Unbound Fields

Data Shaping

• How to: Add Custom Totals
• How to: Calculate Multiple Custom Totals with Custom Summary Type
• How to: Calculate Running Totals
• How to: Apply a Filter
• How to: Implement the Group Filter
• How to: Change the Prefilter's filter criteria in code
• How to: Display Underlying Records
• How to: Group Date-Time Values
• How to: Implement Custom Group Intervals
• How to: Implement Custom Summary
• How to: Sort Data by a Data Field
• 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 Using Custom Sorting Algorithm
• How to: Sort Data by OLAP Member Properties
• How to: Prevent End-Users From Changing Filter Conditions
• How to: Replace Default Filter Items with Custom Ones
• How to: Add and Remove Items From Filter Drop-Down Lists
• How to: Sort Filter Drop-Down Items in a Custom Manner
• How to: Locate a Column (Row) Header By Its Column's (Row's) Summary Values

Data Analysis

• How to: Visualize Pivot Grid Data using the Chart Control
• How to: Customize a PivotGrid Control's Data before Displaying It in a Chart Control
• How to: Display KPI Graphics in ASPxPivotGrid Control Bound to a Regular Data Source

Data Formatting

• How to: Format Cell Values
• How to: Format Cells via Events

Layout

• How to: Group Fields
• How to: Split Field Value Cells
• How to: Hide Individual Rows and Columns

Appearance

• How to: Customize Cell Styles via Event
• How to: Customize Cell Appearance via Templates

Data Export

• How to: Export the Pivot Grid's Data to a File
• How to: Customize a Cell in the Exported Excel Document

Miscellaneous

• How to: Save and Restore Layout
• How to: Implement a Custom Serializer
• How to: Save and Load Field Values' Collapsed States Together With Pivot Grid's Layout