DevExpress WinForms Pivot Grid (PivotGridControl)

PivotGridControl (namespace DevExpress.XtraPivotGrid) is a cross-tabulation control that summarizes bound data across row and column dimensions — like an Excel PivotTable. Fields are assigned to four areas (Row, Column, Data, Filter); the control computes summaries at every intersection.

Before You Start — Ask the Developer

If the host agent has a structured question-asking tool available, use it to ask these questions one at a time with clear options — for example, Claude Code's AskUserQuestion tool or GitHub Copilot's askQuestions tool. If no such tool is available, ask the questions directly in the chat response before generating code.

1. Data source? In-memory List<T>/DataTable, EF/EF Core, an OLAP cube (SSAS), or an Excel file? This decides the binding approach (see the Decision Guide).
2. Which fields go where? Which columns become Row / Column / Data / Filter fields, and which need calculated or grouped bindings (ExpressionDataBinding, GroupInterval)?
3. Summaries? Default Sum, or other SummaryType / custom summaries? Any % of total / running totals?
4. Layout & interactivity? Should end users rearrange fields (Customization Form), or is the layout fixed in code?
5. Formatting? Cell number formats, conditional formatting (FormatRules: bars/scales/icons), and appearance/skin requirements?
6. Scale & responsiveness? Large in-memory data → Optimized engine + UseAsyncMode. Large database table → server mode (EntityServerModeSource) so aggregation runs in SQL.
7. Persistence? Save/restore the layout (SaveLayoutToXml / RestoreLayoutFromXml)?

Reference Files