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: