devexpress-wpf-pivot-grid

DevExpress WPF Pivot Grid (PivotGridControl)

The DevExpress WPF Pivot Grid (DevExpress.Xpf.PivotGrid.PivotGridControl) creates pivot tables for multi-dimensional data analysis. Large data sets are summarized in a cross-tabular layout that end users can sort, group, filter, drill down into, and visualize with charts or KPIs. Fields are positioned in four header areas — Row, Column, Data, Filter — and users can drag them between areas at runtime to reshape the report. Unlike GridControl (which uses ItemsSource), the Pivot Grid binds via the DataSource property and creates PivotGridField objects bound to columns of that source.

PivotGrid vs. GridControl: GridControl is for tabular records — each row is one record. PivotGridControl is for aggregated data — each cell is a calculation (sum, count, average) at the intersection of row and column field values. If you need to show a list of orders, use GridControl. If you need to see "total sales per Country × Year", use PivotGridControl.

When to Use This Skill

Use this skill when you need to:

• Build a cross-tab report from a DataTable, list, or query result
• Bind to a Microsoft Analysis Services OLAP cube
• Bind to a server-mode source (very large data, server-side aggregation)
• Bind to in-memory data (List<T>) with the Optimized processing engine
• Bind asynchronously (background-thread data fetch and aggregation)
• Create fields in the Row, Column, Data, or Filter area programmatically
• Apply grouping intervals (DateYear, DateMonth, Alphabetical, custom numeric ranges)
• Customize aggregation functions (Sum, Count, Average, Min, Max, Custom)
• Add KPI displays for executive dashboards
• Apply conditional formatting (Excel-style cell formatting)
• Integrate with ChartControl for visual drill-down
• Print, preview, or export to PDF / XLSX / HTML / CSV / RTF / MHT / TXT
• Save and restore pivot layout across sessions
• Migrate from Microsoft PivotTable or third-party pivot controls