Examples
- 3 minutes to read
This section provides a list of examples, grouped by features, contained in this help.
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 Datasource
- 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
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 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