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.5
23.1.12
22.1.14
18.1.18
Release Date
15-August-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.

Tag <dxtransform> is invalid. Transformation failed: An error occurred while loading document '../../../App_Data/GeneratedData/ProductsStructure.xml'. See InnerException for a complete description of the error.

* 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 19 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.

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