Examples
- 2 minutes 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
Layout
Appearance
Data Export
- How to: Export the Pivot Grid’s Data to a File
- How to: Customize a Cell in the Exported Excel Document