Super Fast Pivot Analysis

Analyze enterprise data faster - much faster.

DevExpress Pivot Grid control is built for speed. With its in-memory Data Processing Engine and greatest performance, you can process and summarize enormous volumes of data at incredibly fast speeds. The PivotGrid gives the highest possible performance to its data processing and crosstab reporting features, including aggregations and window functions.

See how DevExpress Pivot Grid compares to the competition and why we think it has no equal in the marketplace. Feel free to download our newest release and put the Pivot Grid's data processing engine through its paces.

WPF Pivot Grid | DevExpress

Microsoft Analysis Services (OLAP)

Leverage multi-dimensional data analysis.

The Pivot Grid control fully supports Microsoft Analysis Services (OLAP) cubes. When bound an OLAP cube, the PivotGrid automatically delegates all data management and calculations to the server. Supported data providers include: OLEDB for OLAP, ADOMD.NET, and XMLA.

DevExpress PivotGrid also includes the following data analysis options:

  • OLAP Drill Down
  • OLAP KPI (Key Performance Indicators)
  • Calculated OLAP Fields (MDX)
Microsoft Analysis Services (OLAP) - WPF Pivot Grid | DevExpress

Data Filters

Locate information with multiple search tools.

Filtering is the basic feature used to quickly highlight data you want to draw attention to. The Pivot Grid includes comprehensive set of filtering and custom query options:

  • Excel Inspired Filtering
  • Query Builder / Filter Criteria Editor
  • Custom Filter UI
  • Filter Panel & Most Recently Used (MRU) Filters
  • Comprehensive API / Create Custom Filters
Data Filtering - WPF Pivot Grid | DevExpress

Conditional Formatting

Highlight values for maximum data clarity.

The Pivot Grid ships with Microsoft Excel inspired Conditional Formatting. This powerful feature allows you to highlight cells/rows based on a certain criteria without writing a single line of code. Cells/rows can be highlighted with data bars, icons, and predefined color scales. At runtime, users can easily create and apply style conditions by activating the Pivot Grid's popup menu.

Conditional Formatting - WPF Pivot Grid | DevExpress

Shape & Analyze Pivot Data

Deliver personalized UI for in-depth data analysis.

Big data is only helpful when it is accurately and effectively analyzed. With its powerful data architecture, our WPF Pivot Grid is able to slice and dice information efficiently and intuitively present it to end-users. The Pivot Grid delivers a myriad of data shaping and aggregation options, including:

  • Automatic Summaries (Average, Count, Max, Min, Sum, and Var) / Custom Summary
  • Window Calculations & Custom Expressions
  • Automatic Totals / Custom Totals / Running Totals
  • Multi-Field Sorting & Top N
  • Sorting / Data Grouping / Interval Grouping
  • Drill-Down
Data Shaping and Data Analysis - WPF Pivot Grid | DevExpress

WPF Application Themes

Over 50 Themes and 40 Color Palettes Designed to Amaze

You can specify a theme when you ship your app or allow end-user to modify the look and feel of your WPF application on the fly. Our themes come with color palettes that can personalize your UI even further. And yes, you can customize our pre-built application themes with the free DevExpress WPF Theme Designer. The following are a few of the themes included in our distribution.

Windows 10 Light - Default Palette | DevExpress

Windows 10 Light

Default Palette

Office 2019 Colorful - SpruceLeaves Palette | DevExpress

Office 2019 Colorful

SpruceLeaves Palette

VS 2019 Dark - BlueberryCake Palette | DevExpress

VS 2019 Dark

BlueberryCake Palette

Office 2019 High Contrast | DevExpress

Office 2019

High Contrast

Chart Pivot Data

Visualize pivot data with ease.

DevExpress WPF Charts can load and visualize data directly from the Pivot Grid. The chart will also update instantly to reflect the changes made in the Pivot Grid.

Integration with Charts - WPF Pivot Grid | DevExpress

Exceptional UI/UX Customization

Easy-to-use and highly customizable pivot table.

Deliver powerful runtime experiences that empower end-users. The Pivot Grid's vast array of UI/UX customization features means you can build fully customizable pivot tables with ease.

  • Field Groups
  • Compact Layout
  • Best Fit Columns
  • Pinned/Fixed Columns
  • Multiple-Cell Selection
  • Save/Restore Layout
  • Field Customization via Drag&Drop
  • Horizontal and Vertical Scrolling
UI/UX Customization - WPF Pivot Grid | DevExpress

Reporting Made Easy

Preview. Print. Export.

Our Pivot Grid is not just for on-screen data analysis. With it, you can render its content to paper just like a traditional WYSIWYG report. You can also export data to numerous file formats.

With its API, you can save your data as PDF, XLS, XLSX, MHT, CSV, HTML, RTF, DOCX, TXT or as Image.

Reporting and Printing - WPF Pivot Grid | DevExpress

Intuitive MVVM Support

Fully compatible with the MVVM design pattern.

The Pivot Grid control ships with the comprehensive MVVM support. You can easily generate the following UI elements based on your view model:

  • Fields
  • Groups
  • Format Conditions
MVVM Support - WPF Pivot Grid | DevExpress

Start your free 30-day trial today!

Download our fully-functional 30-day trial today and
experience the DevExpress difference.

 

Download Free Trial

Additional Info

WPF Themes and App Skins

The DevExpress WPF Subscription ships with over 50 custom designed and highly polished themes for your next WPF application. You can use each of these themes easily, without modification or manipulate them using our free WPF Theme Designer application. Learn more about theme designer

Touch Enabled User Experience

Deliver elegant, touch-enabled WPF applications using the platform you know and love. The WPF Subscription helps you leverage your current investments and address customer needs via a comprehensive range of WPF controls that support touch on both Windows 7 and Windows 10.

Sec 508 and Accessibility

The DevExpress WPF Subscription makes it easy to create WPF applications that meet government regulations regarding web accessibility. Sec 508 and Accessibility Guidelines 1.0 support is available for key DevExpress WPF controls. Learn more about accessibility

Straightforward Localization

All DevExpress WPF controls can be easily localized using satellite resource assemblies. DevExpress delivers satellite assemblies for a large variety of languages and cultures. To make it easy to get started, resource files for three cultures are included to our installation: German, Japanese, and Spanish. If you need to modify our shipping resources or create satellite assemblies for a different language, simply use our Online Localization Service, a free tool for our active WPF subscribers. Online Localization Service

MVVM Support

DevExpress WPF Controls have been engineered to support the Model-View-ViewModel development pattern. Controls such as the DevExpress WPF Grid provide the same level of MVVM support as the standard Microsoft Data Grid along with additional features not available from Microsoft. DevExpress controls allow you to generate columns based on data and customize them using WPF styles without limitations. Learn more about MVVM support

Free 30-Day TrialSee What's New

Supported IDEs

Review the list of development tools and frameworks supported by our products. We strongly recommend that you always download and use the most recent versions. If the latest version does not support the IDE or framework you're using, please submit a support ticket via the DevExpress Support Center and request an evaluation version that suits your requirements.

Version
24.1.6
23.1.12
22.1.14
18.1.18
Release Date
20-September-2024
15-August-2024
7-May-2024
5-May-2022
Support Status
Supported
Limited Support
Not Supported
(for legacy apps)
Not Supported
(for legacy apps)
Minor Updates
Yes
No
No
No
Security Updates
Yes
Yes
No
No
Supported Frameworks
.NET 6 / .NET 7 / .NET 8
.NET Framework 4.5.2+
.NET 6 / .NET 7
.NET Framework 4.5.2+
.NET Core 3+
.NET 6
.NET 5
.NET Framework 4.5.2+
.NET Framework 4.0+
Supported IDE
Visual Studio 2022
Visual Studio 2019
Visual Studio 2017
Visual Studio 2015
Visual Studio 2022
Visual Studio 2019
Visual Studio 2017
Visual Studio 2015
Visual Studio 2022
Visual Studio 2019
Visual Studio 2017
Visual Studio 2015
Visual Studio 2013
Visual Studio 2012
Visual Studio 2019
Visual Studio 2017
Visual Studio 2015
Visual Studio 2013
Visual Studio 2012
Visual Studio 2010

Buy this product as part of the following subscription packages.

We are so confident in our products that we back them with a 60 day no questions asked money back guarantee. If within the first 60 days of ownership you are not satisfied with the capabilities of our tools, you can request a full refund of the amount you paid to DevExpress by writing to clientservices@devexpress.com or by calling +1 (818) 844-3383.

Best Value
WinForms Controls
.NET 6 / .NET 7 / .NET 8 Support
Data Grid
DirectX Hardware Acceleration
HTML & CSS Markup Support
Charting
Gantt
Spreadsheet
Rich Text Editor
Calendar & Scheduling
Diagrams
Ribbon
Toolbar-Menu
DirectX Form
Dock Windows
Pivot Grid
Tree List
TreeMap
Property Grid
PDF Viewer
Sankey Diagram
Sunburst
Layout Manager
Map Control
Heat Map
Gauge Controls
Navigation Pane
Tile Control
Live Tile Manager
Printing & Exporting
Spell Checker
Data Editors
MVVM Framework
Themes and Skinning
WPF Controls
.NET 6 / .NET 7 / .NET 8 Support
Data Grid
Tree List
Property Grid
Charting
Pivot Grid
Calendar & Scheduling
Spreadsheet
Rich Text Editor
Spell Checker
PDF Viewer
Diagrams
Sankey Diagram
Ribbon
Toolbar-Menu
TreeView
Dock Windows
Layout Manager
Navigation Controls
Data Editors
Map Control
Heat Map
Sunburst
TreeMap
Gantt Control
Gauge Controls
Printing and Exporting
MVVM Framework
Application Themes
Blazor UI Components
Grid
Bar Gauge
Charts
Data Editors
Dialogs & Windows
File Management
HTML Editor
PDF Viewer
Layout
Map
Navigation
Pivot Grid
Reports
Rich Text Editor
Scheduler
TreeList
BI Dashboard
.NET MAUI Controls with Support
Data Grid
CollectionView
Charts
Scheduler
PDF Viewer
Bottom Sheet
Data Editors
Data Form & Form Components
HTML Editor
Image Control
Layout Panels
Popup
Circular Gauge
Shimmer Control
Tabs
Toolbar
Tree View
.NET MAUI Project Templates
Office File API Support
jQuery Components
Data Grid
Charting
Calendar & Scheduling
Pivot Grid
TreeList
HTML/Markdown Editor
Diagram
Gantt
File Management
Form Layout
Data Editors
Gauge Components
Map Components
Navigation and Layout
Dialogs and Notifications
Actions and Lists
Data Export
Theme Builder
Angular Components
Data Grid
Charting
Calendar & Scheduling
Pivot Grid
TreeList
HTML/Markdown Editor
Diagram
Gantt
File Management
Form Layout
Data Editors
Gauge Components
Map Components
Navigation and Layout
Dialogs and Notifications
Actions and Lists
Data Export
Theme Builder
React Components
Data Grid
Charting
Calendar & Scheduling
Pivot Grid
TreeList
HTML/Markdown Editor
Diagram
Gantt
File Management
Form Layout
Data Editors
Gauge Components
Map Components
Navigation and Layout
Dialogs and Notifications
Actions and Lists
Data Export
Theme Builder
Vue Components
Data Grid
Charting
Calendar & Scheduling
Pivot Grid
TreeList
HTML/Markdown Editor
Diagram
Gantt
File Management
Form Layout
Data Editors
Gauge Components
Map Components
Navigation and Layout
Dialogs and Notifications
Actions and Lists
Data Export
Theme Builder
ASP.NET Web Forms Controls
Data Grid
Charting
Ribbon
Spreadsheet
Rich Text Editor
Calendar & Scheduling
Card View
Site Navigation
Page Layout
Docking and Popups
Pivot Grid
Tree List
TreeView
Vertical Grid
HTML Editor
Gauge Controls
Data Browsing
Image Browsing
File Management
Multi-Purpose Site Controls
Printing & Exporting
Spell Checker
Data Editors
Themes and Skinning
Diagram
Gantt
ASP.NET MVC Extensions
Data Grid
Charting
Ribbon
Spreadsheet
Rich Text Editor
Calendar & Scheduling
Card View
Page Layout
Site Navigation
Docking and Popups
Pivot Grid
Tree List
TreeView
Vertical Grid
HTML Editor
Data Browsing
Image Browsing
File Management
Printing & Exporting
Spell Checker
Data Editors
Themes and Skinning
Diagram
Gantt
ASP.NET MVC Client-Side Controls
Data Grid
Charting
Calendar & Scheduling
Pivot Grid
TreeList
HTML/Markdown Editor
Diagram
Gantt
File Management
Form Layout
Data Editors
Gauge Controls
Map Control
Web Navigation and Layout
Dialogs and Notifications
Multi-Purpose Web Controls
Data Export
Theme Builder
ASP.NET Core Controls
.NET 6 / .NET 7 / .NET 8 Support
Data Grid
Charting
Calendar & Scheduling
Pivot Grid
TreeList
HTML/Markdown Editor
Diagram
Gantt
File Management
Form Layout
Data Editors
Gauge Controls
Map Control
Web Navigation and Layout
Dialogs and Notifications
Multi-Purpose Web Controls
Data Export
Theme Builder
ASP.NET Core Office Controls
.NET 6 / .NET 7 / .NET 8 Support
Spreadsheet
Rich Text Editor
Printing & Export
ASP.NET Bootstrap Controls
Data Grid
CardView
Charting
Ribbon
Rich Text Editor
File Manager
Scheduler
Site Navigation and Layout
Sparkline
Spreadsheet
Data Editors
Themes and Skinning
Reporting
.NET 6 / .NET 7 / .NET 8 Support
Visual Studio Report Designer
WinForms Document Viewer
WinForms End-User Report Designer
Document Viewer (ASP.NET Web Forms, MVC, Core)
Web Report Designer (ASP.NET Web Forms, MVC, Core)
Native Blazor Document Viewer (Server, WebAssembly)
Blazor Web Report Designer (Server, WebAssembly)
WPF Document Viewer
WPF End-User Report Designer
Native Angular Document Viewer
Angular End-User Report Designer
Native React Document Viewer
React End-User Report Designer
XPO - ORM Library
High Performance ORM
Full Support for 12 Database Engines
.NET 6 / .NET 7 / .NET 8 Support
Visual Data Model Designer
Office File API
.NET 6 / .NET 7 / .NET 8 Support
Non-Windows Environment Support (Linux, macOS, Azure, AWS)
Spreadsheet Document API (create, edit, update XLSX, XLS, CSV)
Export to Excel (XLSX, XLS, CSV)
Word Processing Document API (create, edit, update DOC/DOCX, RTF, HTML, etc.)
PDF Document API
Digital Signature API
Barcode Generation API
Zip Compression and Archive API
Unit Conversion API
Business Intelligence Dashboard
.NET 6 / .NET 7 / .NET 8 Support
WinForms Dashboard Viewer
WinForms End-User Dashboard Designer
WPF Dashboard Viewer
Blazor Dashboard Component
ASP.NET Core Dashboard Control (includes End-User Designer)
ASP.NET Web Forms Dashboard Control (includes End-User Designer)
ASP.NET MVC Dashboard Control (includes End-User Designer)
HTML JS Dashboard Control (includes End-User Designer)
Dashboard Component for Angular (includes End-User Designer)
Dashboard Component for React (includes End-User Designer)
Dashboard Component for Vue (includes End-User Designer)
VS Dashboard Designer
XAF - Cross-Platform .NET App UI
.NET 6, 7, 8 / .NET Framework
WinForms, ASP.NET Core Blazor, ASP.NET Web Forms
Backend Web API Service
Entity Framework Core and XPO ORM Support
Multi-Tenancy Support
Role-based Access Control, Permission Management
Administrative UI (Manage Users & Roles at Runtime)
Audit Trail (History of Data Changes)
Validation (Prevent Data Errors)
Reporting (Shape, Export & Print Data)
Analytics (Dashboard, Chart, Pivot, Map)
Office Documents (Edit Rich Text & Spreadsheets)
File Attachments (Store Custom Files)
Clone Object (Copy Data Records)
Business Process Management (Workflow & State Machine)
Conditional Appearance (Manage UI Element State)
Event Planning (Scheduler & Notifications)
Tree List Editors (Organize Hierarchical Data)
Localization
Themes
.NET App Security & Web API Service
Entity Framework Core ORM Support
XPO ORM Support
Role-based Access Control & Permission Management
ASP.NET Core Web API / OData Service for CRUD and Authorization
Administrative UI to Manage Users and Roles at Runtime
Download Reports
Download File Attachments
Obtain Localized Strings
Validate Data
Audit Data Changes
CodeRush for Visual Studio
VS 2022 Support
VS 2019 Support
VS 2017 Support
VS 2015 Support
Roslyn-Powered Superior Performance
C#, VB.NET, XAML
TestCafe Studio: Functional Web Testing
Coded UI Support for WinForms Controls
Source Code *
WinForms Controls
ASP.NET Controls
WPF Controls
JavaScript - jQuery, Angular, React
Blazor UI Components
Reporting
.NET MAUI Controls with Support
XPO - ORM Library
Office File API
Data Visualization Dashboard
XAF - Cross-Platform .NET App UI
Technical Support
Priority Support

* DevExpress does not include/ship source code for certain products, including CodeRush, TestCafe Studio, and Report & Dashboard Server.

Best in Class Tools

DevExpress is honored to have been voted best in class 18 times in this year's Visual Studio Magazine Reader's Choice Awards.

Experience the DevExpress difference and see why your peers consistently vote our products #1. With our Universal Subscription, you will build your best, see complex software with greater clarity, increase your productivity and create stunning applications for Windows, Web and your Mobile world.

18 VSM Awards in 2024 x18
19 VSM Awards in 2023 x19
20 VSM Awards in 2022 x20
20 VSM Awards in 2021 x20