DevExpress.Wpf.PivotGrid 26.1.7-pre-26311
DevExpress WPF Pivot Grid
The DevExpress.Wpf.PivotGrid includes the DevExpress Pivot Grid control for WPF applications. Use the PivotGridControl to summarize, organize, and analyze large volumes of data in an Excel-like cross-tabular layout.
The control allows users to rearrange fields, group and filter data, calculate summaries, drill down to underlying records, apply conditional formatting, and export analysis results.
Key Features
- PivotGridControl - Displays multidimensional data in a cross-tabular format.
- Data Summaries - Calculates totals and summaries such as Sum, Average, Count, Minimum, and Maximum.
- Data Shaping - Supports sorting, grouping, filtering, field reordering, and Top N value analysis.
- Drill-Down - Retrieves the source records used to calculate an individual summary value.
- Conditional Formatting - Highlights important values with appearance rules, color scales, data bars, and icons.
- Data Binding - Connects the Pivot Grid to collections, databases, server-mode sources, Excel files, XML, and OLAP cubes.
- Layout Persistence - Saves and restores field positions, sorting, grouping, filtering, and other layout settings.
- Printing and Export - Prints Pivot Grid data and exports it to PDF, HTML, MHT, RTF, TXT, CSV, XLS, and XLSX formats.
Examples
Display and Configure a Pivot Grid
<dxpg:PivotGridControl ItemsSource="{Binding Sales}">
<dxpg:PivotGridControl.Fields>
<dxpg:PivotGridField FieldName="Region" Area="RowArea"/>
<dxpg:PivotGridField FieldName="Category" Area="ColumnArea"/>
<dxpg:PivotGridField FieldName="Amount"
Area="DataArea"
SummaryType="Sum"/>
</dxpg:PivotGridControl.Fields>
</dxpg:PivotGridControl>
Users can drag field headers between the row, column, data, and filter areas to change how the Pivot Grid organizes and summarizes data.
Export Pivot Grid Data to XLSX
The following example exports the current Pivot Grid data to an XLSX file.
pivotGridControl.ExportToXlsx("Sales.xlsx");
The Pivot Grid supports data-aware export for Excel formats and exports data to multiple document formats.
Save and Restore the Pivot Grid Layout
The following example saves the Pivot Grid layout to an XML file and restores it using the RestoreLayoutFromXml method.
pivotGridControl.SaveLayoutToXml("Layout.xml");
// ...
pivotGridControl.RestoreLayoutFromXml("Layout.xml");
Evaluation Period, Pricing Options, and Licensing Terms
Whether you own a license or want to start a 30-day evaluation period, register your DevExpress license key. To obtain your key, log in to the DevExpress Download Manager. Use your existing DevExpress.com account or create a new account for free.
For additional registration instructions, see License Key for DevExpress Products.
If you purchase a license after evaluating the product, re-register your updated DevExpress license key to remove evaluation version warnings and messages.
This package is included in the following commercial subscriptions:
See DevExpress Subscriptions & Licensing for subscription comparison tables, purchasing FAQ, and licensing information.
Documentation
Software Bill of Materials (SBOM)
To access SBOM files for DevExpress packages, please refer to the following article: Software Bill of Materials (SBOM) for DevExpress .NET assemblies/NuGet packages, JavaScript, VCL and other redistributable artifacts.
See Also: Information Security | Security - What You Need to Know
Useful Online Resources
Showing the top 20 packages that depend on DevExpress.Wpf.PivotGrid.
| Packages | Downloads |
|---|---|
|
DevExpress.Wpf
Target Platform/Framework: Desktop
DevExpress Product Libraries Used: WPF UI components (https://www.devexpress.com/wpf)
Available in the following DevExpress Subscription(s): Universal, DXperience, WPF
|
2 |
|
DevExpress.Wpf
Target Platform/Framework: Desktop
DevExpress Product Libraries Used: WPF UI components (https://www.devexpress.com/wpf)
Available in the following DevExpress Subscription(s): Universal, DXperience, WPF
|
3 |
|
DevExpress.Wpf.Dashboard
Target Platform/Framework: Desktop
DevExpress Product Libraries Used: BI Dashboard (https://www.devexpress.com/dashboard)
Available in the following DevExpress Subscription(s): Universal
|
3 |
|
DevExpress.Wpf.PivotGrid.de
Target Platform/Framework: Desktop
DevExpress Product Libraries Used: WPF UI components (https://www.devexpress.com/wpf)
Available in the following DevExpress Subscription(s): Universal, DXperience, WPF, Reporting
|
3 |
|
DevExpress.Wpf.PivotGrid.es
Target Platform/Framework: Desktop
DevExpress Product Libraries Used: WPF UI components (https://www.devexpress.com/wpf)
Available in the following DevExpress Subscription(s): Universal, DXperience, WPF, Reporting
|
3 |
|
DevExpress.Wpf.PivotGrid.ja
Target Platform/Framework: Desktop
DevExpress Product Libraries Used: WPF UI components (https://www.devexpress.com/wpf)
Available in the following DevExpress Subscription(s): Universal, DXperience, WPF, Reporting
|
2 |
|
DevExpress.Wpf.PivotGrid.ja
Target Platform/Framework: Desktop
DevExpress Product Libraries Used: WPF UI components (https://www.devexpress.com/wpf)
Available in the following DevExpress Subscription(s): Universal, DXperience, WPF, Reporting
|
3 |
|
DevExpress.Wpf.Reporting
Target Platform/Framework: Desktop
DevExpress Product Libraries Used: .NET Reporting (https://www.devexpress.com/subscriptions/reporting)
Available in the following DevExpress Subscription(s): Universal, DXperience, WPF, Reporting
|
3 |
|
DevExpress.Wpf.TypedStyles
Target Platform/Framework: Desktop
DevExpress Product Libraries Used: WPF UI components (https://www.devexpress.com/wpf)
Available in the following DevExpress Subscription(s): Universal, DXperience, WPF
|
2 |
|
DevExpress.Wpf.TypedStyles
Target Platform/Framework: Desktop
DevExpress Product Libraries Used: WPF UI components (https://www.devexpress.com/wpf)
Available in the following DevExpress Subscription(s): Universal, DXperience, WPF
|
3 |
|
DevExpress.Wpf.TypedStyles
This package provides TypedStyles for controls from base WPF assemblies and DevExpress WPF controls.
|
2 |
.NET Framework 4.6.2
- DevExpress.Data (= 26.1.7-pre-26311)
- DevExpress.Data.Desktop (= 26.1.7-pre-26311)
- DevExpress.Mvvm (= 26.1.7-pre-26311)
- DevExpress.PivotGrid.Core (= 26.1.7-pre-26311)
- DevExpress.Printing.Core (= 26.1.7-pre-26311)
- DevExpress.Wpf.Charts (= 26.1.7-pre-26311)
- DevExpress.Wpf.Core (= 26.1.7-pre-26311)
- DevExpress.Wpf.Grid (= 26.1.7-pre-26311)
- DevExpress.Wpf.Grid.Core (= 26.1.7-pre-26311)
- DevExpress.Wpf.Printing (= 26.1.7-pre-26311)
.NET 8.0
- DevExpress.Data (= 26.1.7-pre-26311)
- DevExpress.Data.Desktop (= 26.1.7-pre-26311)
- DevExpress.Mvvm (= 26.1.7-pre-26311)
- DevExpress.PivotGrid.Core (= 26.1.7-pre-26311)
- DevExpress.Printing.Core (= 26.1.7-pre-26311)
- DevExpress.Wpf.Charts (= 26.1.7-pre-26311)
- DevExpress.Wpf.Core (= 26.1.7-pre-26311)
- DevExpress.Wpf.Grid (= 26.1.7-pre-26311)
- DevExpress.Wpf.Grid.Core (= 26.1.7-pre-26311)
- DevExpress.Wpf.Printing (= 26.1.7-pre-26311)
.NET 9.0
- DevExpress.Data (= 26.1.7-pre-26311)
- DevExpress.Data.Desktop (= 26.1.7-pre-26311)
- DevExpress.Mvvm (= 26.1.7-pre-26311)
- DevExpress.PivotGrid.Core (= 26.1.7-pre-26311)
- DevExpress.Printing.Core (= 26.1.7-pre-26311)
- DevExpress.Wpf.Charts (= 26.1.7-pre-26311)
- DevExpress.Wpf.Core (= 26.1.7-pre-26311)
- DevExpress.Wpf.Grid (= 26.1.7-pre-26311)
- DevExpress.Wpf.Grid.Core (= 26.1.7-pre-26311)
- DevExpress.Wpf.Printing (= 26.1.7-pre-26311)
.NET 10.0
- DevExpress.Data (= 26.1.7-pre-26311)
- DevExpress.Data.Desktop (= 26.1.7-pre-26311)
- DevExpress.Mvvm (= 26.1.7-pre-26311)
- DevExpress.PivotGrid.Core (= 26.1.7-pre-26311)
- DevExpress.Printing.Core (= 26.1.7-pre-26311)
- DevExpress.Wpf.Charts (= 26.1.7-pre-26311)
- DevExpress.Wpf.Core (= 26.1.7-pre-26311)
- DevExpress.Wpf.Grid (= 26.1.7-pre-26311)
- DevExpress.Wpf.Grid.Core (= 26.1.7-pre-26311)
- DevExpress.Wpf.Printing (= 26.1.7-pre-26311)
| Version | Downloads | Last updated |
|---|---|---|
| 26.1.7-pre-26318 | 0 | 11/19/2026 |
| 26.1.7-pre-26311 | 2 | 11/15/2026 |
| 26.1.6 | 2 | 11/15/2026 |
| 26.1.6-pre-26304 | 2 | 11/15/2026 |
| 26.1.6-pre-26277 | 2 | 11/15/2026 |
| 26.1.6-pre-26270 | 2 | 11/15/2026 |
| 26.1.5 | 2 | 11/15/2026 |
| 26.1.4 | 2 | 11/15/2026 |
| 26.1.3 | 2 | 11/15/2026 |
| 25.2.11 | 3 | 11/11/2026 |
| 25.2.10 | 2 | 11/15/2026 |
| 25.2.9 | 2 | 11/15/2026 |
| 25.2.8 | 2 | 11/15/2026 |
| 25.2.7 | 3 | 11/11/2026 |
| 25.2.6 | 2 | 11/15/2026 |
| 25.2.5 | 2 | 11/15/2026 |
| 25.2.4 | 1 | 11/15/2026 |
| 25.2.3 | 2 | 11/15/2026 |
| 25.1.15 | 2 | 11/15/2026 |
| 25.1.14 | 2 | 11/15/2026 |
| 25.1.13 | 2 | 11/15/2026 |
| 25.1.12 | 1 | 11/15/2026 |
| 25.1.11 | 2 | 11/15/2026 |
| 25.1.10 | 2 | 11/15/2026 |
| 25.1.9 | 2 | 11/15/2026 |
| 25.1.8 | 2 | 11/15/2026 |
| 25.1.7 | 2 | 11/15/2026 |
| 25.1.6 | 2 | 11/15/2026 |
| 25.1.5 | 2 | 11/15/2026 |
| 25.1.4 | 2 | 11/15/2026 |
| 25.1.3 | 2 | 11/15/2026 |