devexpress-wpf-pivot-grid

What problem does it solve?

This Skill eliminates the complexity of implementing multi-dimensional data analysis in WPF applications by providing accurate DevExpress PivotGridControl API patterns, correct import paths, and ready-to-run code examples for data binding, aggregation, grouping, filtering, and export scenarios.

Core Features & Use Cases

• Multi-dimensional data binding: Connect to DataTable, List<T>, Entity Framework, OLAP cubes, or server-mode sources using the correct DataSource property and processing engine settings.
• Field configuration and layout: Create PivotGridField objects, position them in Row/Column/Data/Filter areas, and apply grouping intervals, aggregation functions, and sorting rules.
• Advanced analytics and export: Implement drill-down, KPI displays, conditional formatting, chart integration, and export to PDF/XLSX with proper DevExpress APIs.
• Use Case: A developer building a sales dashboard needs to display total sales by country and year. This Skill provides the exact code to bind data, configure date grouping, and render a functional pivot table in minutes.

Quick Start

Use the devexpress-wpf-pivot-grid skill to bind a WPF PivotGridControl to a sales DataTable, configure Country and Year fields with date grouping, and display aggregated sales amounts in a cross-tabular layout.