[Expand]General Information
[Collapse]WinForms Controls
  .NET Core Support
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications, and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Expand]Property Grid
  [Collapse]Pivot Grid
   [Expand]Getting Started
     Pivot Grid Fields
     Information Presentation Basics
     Hierarchical Value Presentation
     Product Class Structure
     Main Features
   [Expand]Binding to Data
   [Expand]Data Shaping
   [Expand]Data Analysis
   [Expand]Focus and Navigation
   [Expand]Printing and Exporting
   [Expand]Design-Time Features
   [Expand]UI Elements
   [Expand]End-User Capabilities
   [Expand]Member Tables
  [Expand]Tree List
  [Expand]Gantt Control
  [Expand]Chart Control
  [Expand]Map Control
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Sunburst Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Report and Dashboard Server
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Main Features

The DevExpress Pivot Grid provides numerous built-in features that enable you to perform various data analysis tasks. Below is a list of essential features offered by the DevExpress Pivot Grid.

Expanded Data Binding

  • Support for Multiple Datasource Types - The DevExpress Pivot Grid provides full support for regular and custom data sources that implement the IList interface. To learn more, see the Binding to Data topic.
  • MS Analysis Services Support - You can use MS Analysis Services (OLAP) as a data source for a PivotGridControl. To learn more, see the OLAP Data Source topic.

Expanded Data-Related Features

  • Automatic Summary Calculation for Each Cell - Nine summary functions are available. See the PivotSummaryType topic for a complete list of these functions.
  • Custom summaries - Pivot Grid Control provides the capability to calculate summaries manually. To learn more, see the Custom Summaries topic.
  • Any Number of Data Fields - This feature allows you to calculate and display multiple summaries at the intersection of each column and row. To learn more, see the Data Field topic.
  • Any Number of Column and Row Fields - Column and row field values are listed along the top and right edge of the control, and identify column and row headers. The values of multiple column (row) fields are arranged into a hierarchy and can be expanded. To learn more, see the Column Field and Row Field topics.
  • Automatic Total and Grand Total Calculation - Totals are displayed as additional columns or rows containing summarized data. To learn more, see the Totals topic.
  • Grouping Values into Intervals - Specific field values of column and row fields can automatically be grouped into larger categories (ranges). To learn more, see the Grouping topic.
  • Multiple Fields - Multiple fields can be bound to the same data source field, and the values of these fields can be grouped independently.
  • Filtering Data - This feature enables you to limit which records are processed by the PivotGridControl. An end-user can easily change the filter at runtime via the Filter Dropdown. To learn more, see the Filtering topic.
  • Sorting - Pivot Grid Control provides a sorting feature that allows you to manage the sort order, sort data by summary values, and limit the number of displayed field values. To learn more, see the Sorting topic.
  • Obtaining Underlying Data - You can display and browse records used to calculate summaries in specific cells in the grid control. To learn more, see the Obtaining Underlying Data (Drill-Down) topic.
  • End-user Capabilities - The pivot grid provides a wide range of capabilities to end-users such as reordering, filtering and sorting fields, controlling field visibility, etc. To learn more, see the End-User Capabilities topic.

Expanded Miscellaneous

  • Printing and Exporting Support - Pivot Grid Control content can be printed or exported using the XtraPrinting Library. To learn more, see the Printing and Exporting topics.
  • Integration with the Chart Control - The data displayed in the Pivot Grid Control can be visualized using the XtraCharts Suite. To learn more, see the Integration with the Chart Control topic.
  • Layout Saving - The layout of the pivot grid can be saved to and restored from the system registry, an XML file or a stream. To learn more, see the Save and Restore Layout topic.
  • Appearance Customization - The appearance settings used to paint Pivot Grid Control visual elements, provide a consistent look and feel, or paint the control manually can be customized. To learn more, see the Appearance topic.
  • Interface Element Localization - Pivot Grid Control has resources that can be translated into various languages. To learn more, see the Localization topic.

Is this topic helpful?​​​​​​​