When it comes to data mining and multi-dimensional analysis, an advanced and feature complete pivot table control provides business users unrivaled insights into daily operations. Until the release of the DevExpress PivotGrid for .NET, however, using the pivot capabilities of products like MS Excel® meant introducing "out-of-process" solutions within managed applications.

The DevExpress WPF PivotGrid was engineered from the ground-up to eliminate the limitations imposed by these out-of-process solutions and to radically improve the way in which data-centric applications deliver information to end-users. With its powerful data architecture, DXPivotGrid is able to slice and dice information efficiently and intuitively present it to end-users. It delivers numerous layout customization options with total end-user control over each individual on-screen report.

: DevExpress WPF Pivot Table
Fully Customizable
Actionable On-Screen Analytics

The DevExpress WPF Pivot Grid Control has the power to convert hard to read and difficult to dissect dataset information into compact and summarized visual reports so your application can efficiently address real-time business analysis needs. The fully customizable design of the Pivot Grid ensures that end-users can modify any layout visually in order to examine data from different/multiple perspectives.

Transform Plain-Table Data into a Pivot Report
Use Multiple Data Fields in a Report
Use Manually Calculated Fields
Show Trends Using the Built-in Summary Variation Feature

: DevExpress WPF Pivot Table
Powerful, Fast and Efficient
OLAP Support and Asynchronous Data Processing

Microsoft Analysis Services (OLAP) data sources are fully supported by the WPF Pivot Grid. When bound to this data source type, DXPivotGrid automatically delegates all data management and calculations to the server. Supported data providers include: OLEDB for OLAP, ADOMD.NET and XMLA.

Asynchronous Data Processing: When asynchronous data processing mode is enabled, your application stays responsive while the pivot grid performs necessary calculations.

Unbound Columns and Expression Editor: You can now create unbound fields and populate them with data as your needs dictate.

: DevExpress WPF Pivot Table
Integrated Toolset
Drill-Down, Visualize, Print and Export

Data Drill-Down: With just a single line of code, you can allow your end-users to explore the data underlying all calculated cell values.

Charting: The Pivot Grid Control allows its contents to be visualized using the DevExpress WPF Chart Control.

Print and Export Data: Instant Cross-Tab Reports in printed form, PDF, XLS, and numerous other file formats. DXPivotGrid is not just for on-screen data analysis. With it, you can export data to numerous formats and render its contents to paper just like a traditional WYSIWYG report.

: DevExpress WPF Pivot Table
Summarize with Clarity
Group Values and Hierarchical Data Display

Data Grouping: Provide different levels of detail for flexible data analysis... End-users may not want to browse through each and every unique respondent age value and instead want to see the ages of respondents in intervals such as 21-30, 31-40, etc. Instead of viewing sales by each unique date, they may want to view the sales against months.

Hierarchical Data Display: Field values are automatically arranged into a tree structure with expandable parents. When necessary, end-users are free to expand and collapse child groups in order to view information in a more summarized format.

: DevExpress WPF Pivot Table
On-Screen Shaping and Computation
Data Summaries and Sorting

Automatic and Manually Calculated Totals: The WPF Pivot Grid offers two unique ways with which to display data summaries: an out-of-the-box solution that addresses most common business needs and a completely customizable solution to satisfy the requirements of your most demanding of users.

Sorting, Top or Bottom Numbers: DXPivotGrid makes data analysis more efficient by enabling a two-way approach to data navigation. End-users can locate data by a specific value or find a value by its data.

: DevExpress WPF Pivot Table
Flexibility Built-in
Built-in Filtering, Cell Selection and Persistence

End-User Data Filtering: With the Pivot Grid's built-in visual filtering option, your end-users can manipulate reports on the fly using an easy to understand data filter dialog.

Cell Selection and Clipboard Support: End-users can select multiple cell blocks and copy selections onto the Clipboard.

Saving and Restoring Layouts: With this feature, you can provide layout persistence between application runs or allow end-users to select from a list of predefined layouts.

Download the Free Trial

Includes 30 days of free tech support

Buy it Today

Part of the WPF Subscription
Pricing starts at only
Get started today and see why tens of thousands of developers
worldwide choose DevExpress.


Everything you'll need for your next WPF project.

The 110 controls and libraries that make up the DevExpress WPF Subscription have been engineered to address the UI, analytics and reporting requirements for a broad range of solutions targeting Windows®, Download your free trial today or explore the individual controls that ship as part of this subscription below.
Create compelling business solutions that emulate the look, feel and capabilities of Microsoft Office®.
Reports & Analytics
Harness the power of information and present it to your users so it's always easy-to-use and always customizable.
Navigation & Layout
Reproduce the advanced and highly flexible user interfaces of today's most popular Windows applications.

Chat is one of the many ways you can contact members of the DevExpress Team.
We are available Monday-Friday between 7:30am and 4:30pm Pacific Time.

If you need additional product information, write to us at info@devexpress.com or call us at +1 (818) 844-3383


DevExpress engineers feature-complete Presentation Controls, IDE Productivity Tools, Business Application Frameworks, and Reporting Systems for Visual Studio, Delphi, HTML5 or iOS & Android development. Whether using WPF, ASP.NET, WinForms, HTML5 or Windows 10, DevExpress tools help you build and deliver your best in the shortest time possible.

Copyright © 1998-2018 Developer Express Inc.
All trademarks or registered trademarks are property of their respective owners