Announcing DevExpress Universal v18.1

Built and optimized for desktop, web, and mobile developers alike, DevExpress Universal helps software teams deliver high performance line-of-business apps that amaze.

See What's New

We Thank Our Loyal Customers for Casting Their Votes

DevExpress is honored to have been voted best in class 19 times in 2017 Visual Studio Magazine Readers' Choice Awards.

Read More
Your Success Matters

Your Success Matters

We look forward to working with you and will do whatever we can to make your experience with us a profitable one.

Read More

Learn More about Our WPF Pivot Grid

Learn More

Performance & Data Access
Asynchronous Mode
Eliminate 'screen-freeze' during data-intensive operations.
Asynchronous Mode
With this data loading mode, you can create solutions that remain responsive to end-user actions regardless of the demands placed upon the Pivot Grid. Whenever you bind the DevExpress Pivot Grid to a large dataset, this asynchronous loading mode fetches data on-demand, in a background thread. This ensures that the Pivot Grid does not freeze during data-intensive operations.
Server Mode
Blazing fast and always ready.
Server Mode
Our flexible data loading options allow you to display, edit and shape data against hundreds of thousands of records at incredibly fast speeds. This unmatched performance is achieved because the Pivot Grid allows you to load data on demand and move time-intensive data shaping operations to the server when appropriate.
Drill Down
Get records used to calculate cell values.
Drill Down

The DevExpress WPF PivotGrid allow you to see the data behind a summarized value. Use the pivot grid's CreateDrillDownDataSource method to get the full set of data that backs up that value.

Unbound Fields
Data binding made easy.
Unbound Fields
The DevExpress WPF PivotGrid control allows you to create Unbound Fields which are not bound to any field in the control's underlying data source. These fields should be populated manually. For instance, they can display custom information and even use summary results calculated by the pivot grid.
OLAP KPI
Microsoft Analysis Services Support
OLAP KPI
OLAP KPI

The DevExpress WPF Pivot Grid allows you to display KPI (Key Performance Indicator) values - a collection of calculations associated with a measure group in a cube, with server-defined or client-defined graphics.

"The response from DevExpress is always prompt, detailed and typically includes a code sample. Have used their suite for 4 years and never regretted my choice for one second." Jim Thomas
Data Shaping & Visualization
Sorting
Sort by Summary & Top Values
Sorting

End-users can sort by summary through the context menu by right-clicking an innermost column or row header. Sorting by Summary is available for all fields displayed within the Column Header Area or Row Header Area.

To focus on a smaller portion of a large amount of your PivotTable data for in-depth analysis, you can limit the number of field values to the specified number of topmost values according to the sort order.

Grouping
Group data against an unlimited number of fields.
Grouping

The Pivot Grid allows you to group fields. This lets you quickly see subtotals for a specific set of items to analyze.

For instance, it's possible to create two fields and bind them to the 'Date' field. The first field can group data by years, the second field - by months.

Filtering
Show the data you want and hide the rest.
Filtering
End-users can build simple filter criteria and apply them using a field's filter drop-down.
Prefilter
A simple to use UI for creating advanced filter expressions.
Prefilter
The built-in Prefilter (Query/Filter Builder) gives you and your users more granular control over filter construction. The Prefilter displays filter criteria as a tree structure, where nodes represent simple filter conditions. If the filter criteria consist of multiple filter conditions, the Prefilter contains multiple nodes linked by logical operators into groups.
Totals & Running Totals
Automatic Total and Grand Total calculation.
Totals & Running Totals
Totals & Running Totals

The Pivot Grid control supports three types of totals: automatic totals (subtotals), custom totals and grand totals.

Running totals allow you to calculate cumulative values that correspond to the specified column or row fields.

"I have looked into many different companies but DevExpress was beating them all for my needs in terms of diversity of WPF tools and the quality of them." Matt AlincAlinc Enterprises
Data Analysis, Printing & Export
Conditional Formatting
Highlight cell values for maximum data clarity.
Conditional Formatting
The DevExpress Pivot Grid ships with Microsoft Excel inspired Conditional Formatting support. This powerful feature allows you to highlight cells/rows based on specified criteria without writing a single line of code. Cells/rows can be highlighted with data bars, icons and predefined color scales. At runtime, end-users can easily apply style conditions by activating the Pivot Grid's popup menu.
Integration with Charts
Present information graphically.
Integration with Charts
Present information graphically.
Summaries & Aggregates
Automatic compute summaries across all Pivot Grid fields.
Summaries & Aggregates

We've made it easy for you to use aggregate functions and compute data summaries for rows and columns displayed within our Pivot Grid. The following built-in aggregate functions are available: Average, Count, Max, Min and Sum.

You can also implement your own algorithms and calculate summaries manually.

WYSIWYG Printing
The easiest way to printing the contents of your Pivot Grid.
WYSIWYG Printing

Turn the contents of your Pivot Grid into a printed report with a simple method call.

The Print Options dialog provides printing options that control the Pivot Grid's appearance when it is printed.

Data Export
Export data to XLS, PDF, HTML, TXT, etc.
Data Export

The DevExpress Pivot Grid supports numerous file formats to import and export data: XLS, XLSX, XPS, PDF, TXT, MHT, CSV, HTML and Image formats.

"Never mind that the DevExpress controls are a fantastic, time-saving suite. The online support they offer is worth the price of the product all by itself." Jim Thomas
UI Customization
Field Groups
Combine fields into groups.
Field Groups
Fields can be combined into groups, so that when an end-user drags a field, the entire group is dragged as well.
Customization Form
Runtime column/field customization made easy.
Customization Form
The DevExpress WPF Pivot Grid allows end-users to customize column and row layout at runtime. The PivotGrid's Column Chooser can add/remove both columns and rows with simple drag & drop operations.
Save/Restore Layout
Save and restore runtime grid customizations made by users.
Save/Restore Layout
The Pivot Grid's layout can be saved to and restored from the system registry, an XML file or a stream.
Best Fit
Adjust column width to fully display cell values.
Best Fit
End-users can resize columns to the optimal width to fully display cell values by double-clicking a column's right border.

Buy this product as part of the following subscription packages.

We are so confident in our products and services 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
WPF Controls
ASP.NET WebForms Controls
Printing & Exporting
ASP.NET MVC Extensions
Printing & Exporting
ASP.NET Bootstrap Controls
Themes and Skinning
JavaScript - jQuery, Angular, React
JavaScript - ASP.NET MVC & Core
UWP Controls
Reporting
WinForms Report Viewer
WinForms End-User Report Designer
HTML5 Report Viewer
ASP.NET WebForms Report Viewer
ASP.NET WebForms End-User Report Designer
ASP.NET MVC Report Viewer
ASP.NET MVC End-User Report Designer
ASP.NET Core Report Viewer (CTP)
ASP.NET Core End-User Report Designer (CTP)
WPF Report Viewer
WPF End-User Report Designer
Office File API (Basic)
Excel Export Library
Word Processing Document API (DOC, RTF)
Office File API (Complete)
Native Mobile UI Controls
CodeRush
C#, VB.NET, XAML
CodeRush Classic
VS 2015 Support
VS 2012, 2013 Support
C#, VB.NET, XAML
HTML, ASP.NET, CSS, Razor, JavaScript
Source Code *
WinForms Controls
ASP.NET Controls
WPF Controls
UWP Controls
JavaScript - jQuery, Angular, React
XPO - ORM Library
Office File API
Data Visualization Dashboard
eXpressApp Framework
Technical Support
Priority Support

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

Additional Info

WPF Themes and App Skins

The DevExpress WPF Subscription ships with over 30 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

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.

Built-in, easy-to-use Application Templates

The DevExpress WPF Subscription includes a series of application templates so you can hit the ground. Learn more

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.

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

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 four cultures are included to our installation: German, Japanese, Russian, 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