skills.rest
DevExpress
DevExpressOFFICIAL
Explore all skills by this author →
WebsiteGitHub

devexpress-wpf-pivot-grid

Bind WPF PivotGridControl to data sources and configure fields for aggregation.

39|7|Updated Jun 2, 2026
Search Tags:#csharp#aggregation#data analysis#wpf#xaml#devexpress#pivot grid
One-click install
npx skills add https://github.com/DevExpress/agent-skills --skill devexpress-wpf-pivot-grid
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: devexpress-wpf-pivot-grid
Source: https://github.com/DevExpress/agent-skills/tree/main/plugins/dx-wpf/skills/devexpress-wpf-pivot-grid
Command: npx skills add https://github.com/DevExpress/agent-skills --skill devexpress-wpf-pivot-grid

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) and examples (resource) components.

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.

Frequently Asked Questions about devexpress-wpf-pivot-grid

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create a WPF pivot grid for multi-dimensional data analysis?▼

To create a WPF pivot grid, use the DevExpress PivotGridControl to bind data sources like DataTable or List<T>, configure PivotGridField objects in Row/Column/Data areas, and apply aggregation functions for cross-tabular reporting.

Can I bind an OLAP cube to a WPF pivot grid for server-mode processing?▼

Yes, the DevExpress WPF PivotGridControl supports binding to OLAP cubes and server-mode sources. You must configure the correct DataSource property and processing engine settings to handle large datasets efficiently.

What .NET framework version do I need to use DevExpress pivot tables in WPF?▼

You need .NET 6+ or .NET Framework 4.6.2+ targeting Windows. Valid DevExpress licensing and the correct NuGet package references are also required to implement multi-dimensional pivot table analytics.

How do I export aggregated pivot grid data to PDF or XLSX in a WPF application?▼

You can export aggregated pivot grid data to PDF or XLSX using the proper DevExpress APIs. The Skill provides ready-to-run code examples for export functionality alongside drill-down and conditional formatting features.

What is the best way to group dates by year in a DevExpress WPF pivot table?▼

The best way to group dates by year is to create a PivotGridField for the date column, set its grouping interval to Year, and position it in the Column or Row area to display aggregated sales amounts in a cross-tabular layout.

Why are my WPF pivot grid fields not aggregating data correctly?▼

Fields may not aggregate correctly if the DataSource property or processing engine settings are misconfigured. Ensure you assign the proper aggregation function to each PivotGridField and verify your data source connections.

Related Skills

Explore More Software Engineering Skills→
DevExpressDevExpress
39

devexpress-wpf-tree-list

Build hierarchical data-aware tree controls for WPF using DevExpress TreeListControl.

Official
Advanced
IsKenKenYaIsKenKenYa

Excel Analysis

Analyze Excel spreadsheets by importing data, cleaning it, and generating pivot tables and charts.

Community
Intermediate
DevExpressDevExpress
39

devexpress-wpf-charts

Implement DevExpress WPF ChartControl 2D charts with correct data binding and axis configuration.

Official
Intermediate
DevExpressDevExpress
39

devexpress-blazor-pivot-table

Build interactive DevExpress DxPivotTable components for Blazor applications.

Official
Intermediate