Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Collapse]WPF Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]Controls and Libraries
  [Expand]Windows and Utility Controls
   Dialogs, Notifications and Panels
   Reporting
  [Expand]Data Grid
  [Expand]Ribbon, Bars and Menu
  [Expand]Charts Suite
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Expand]Fundamentals
   [Expand]Binding to Data
   [Expand]Data Shaping
   [Expand]Data Analysis
   [Expand]Layout
    Printing and Exporting
   [Expand]Appearance
   [Expand]MVVM Enhancements
   [Expand]Miscellaneous
   [Expand]UI Elements
   [Expand]End-User Capabilities
   [Expand]Examples
  [Expand]Scheduler
  [Expand]Scheduler (new)
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Tree List
  [Expand]Gauge Controls
  [Expand]Map Control
  [Expand]Layout Management
  [Expand]Windows Modern UI
  [Expand]Printing-Exporting
  [Expand]Data Editors
  [Expand]Navigation Controls
  [Expand]Spell Checker
  [Expand]Property Grid
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Diagram Control
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Pivot Grid

The DevExpress WPF Pivot Grid allows you to create a pivot table for multi-dimensional data analysis. Using the Pivot Grid, large amounts of data can be summarized and represented in a cross-tabular format that can be sorted, grouped and filtered. End-users can customize the layout of the report based on their analysis requirements using simple drag-and-drop operations. The Pivot Grid also supports drill-down (to view the underlying data for calculated cells), printing and exporting to various file formats (such as PDF, XLS and XLSX), and data visualization using the DevExpress Chart Control, KPI or conditional formatting.

Getting Started


If you are a first-time user, you can refer to the following tutorials, videos and read basic information on the Pivot Grid control.

  • Included Components provides information on which components are supplied with the PivotGridControl.
  • Fundamentals gives you basic information on the purpose and functionality of the Pivot Grid control.

These topics demonstrate the control's basic functionality and provide you with step-by-step instructions on how to create simple applications with the help of the Pivot Grid control.

Binding to Data


Topics in this section describe the ways in which you can provide data for the PivotGridControl.

  • Binding to Data Overview
    This topic provides general information on binding to databases, XML files, lists of data created at runtime, etc.
  • Items Source Configuration Wizard
    This topic describes the Items Source Configuration Wizard in which you can establish a connection to various types of data sources such as ADO.NET DataSets, SQL databases, OLAP cubes, etc.
  • OLAP Data Source
    This topic describes how to connect to a Microsoft Analysis Services server (OLAP server), lists supported Analysis Services versions, and provides information on Pivot Grid Control functionality limitations imposed when bound to an OLAP server.
  • Database Server Mode
    This topic describes how to connect a pivot grid control to a database with a large number of records without loss to performance.
  • Unbound Fields
    This topic describes how to provide data to the fields that are not bound to any field in the data source.
  • Asynchronous Mode
    This describes the capability to perform data-aware operations (retrieving data from the server, sorting, grouping, filtering data and calculating summaries) in a background thread.

Data Shaping


This section contain topics that describe data-related features provided by the Pivot Grid control. These include data filtering, value formatting, sorting and grouping data, using summaries, etc.

  • Aggregation provides the capability to process underlying data and display the results of the calculations.
  • Grouping allows you to group field values into categories (ranges) automatically.
  • Sorting is used to re-arrange the records to meet current sort settings. Here you will learn how to limit the number of displayed values, sort data by summary or change a sort order.
  • Filtering provides information about different data filtering ways, from simple approaches to complex filter criteria with multiple conditions.

Data Analysis


This section illustrates the powerful features that help to organize, analyze and interpret Pivot Grid's data.

  • Integration with the Chart Control describes how to visualize data displayed in the pivot grid using the Chart Control. Set a Pivot Grid control as the Chart control data source and display your data as bars, areas, lines and many other forms. Here you will learn how to customize a Chart control to display Pivot Grid data.
  • Conditional Formatting introduces a Microsoft Excel-inspired conditional formatting feature that allows you to change the appearance of individual cells based on specific conditions. This feature helps to highlight important information, identify trends and exceptions, and compare data using the collection of format rules. Here you will learn how to change appearances of Pivot Grid Control cells depending upon cell data or an expression.
  • Key Performance Indicators topic describes how to evaluate business success with the help of KPI, that is a collection of calculations associating with a measure group in a cube. Here you will learn how to work with Key Performance Indicators provided by OLAP cubes.

Layout


The topics in this section describe the ways in which you can manage the PivotGridControl layout (changing the layout of fields and data cells, grouping fields, etc.).

  • Field Groups describes the capability of arranging fields into groups.
  • Customization Form introduces a Customization Form designed to make layout customization easier for end-users.
  • Best Fit describes how to automatically adjust the column width to display its entire content.
  • Save and Restore Layout describes how to save and restore a Pivot Grid Control layout, allowing you to customize a Pivot Grid Control just once and then apply the saved settings to other pivot grids in other applications.

Printing and Exporting


This section contains articles that explain how to export and/or print data displayed within your Pivot Grid. You can export and print Pivot Grid data to a file or stream in various formats - HTML, MHT, PDF, RTF, TXT, CSV, XLS or XLSX.

Appearance


This section contains articles that explain how to provide the desired appearance and visual presentation of Pivot Grid's UI elements (e.g. cells, field headers, field values etc.).

Miscellaneous


To get more information about a Pivot Grid control, see the following sections.

How would you rate this topic?​​​​​​​