Syncfusion WPF Pivot Grid

SyncfusionData Analysis & OLAP Tools.NET

Interactive WPF pivot grid for multidimensional data analysis.

  • Supports dynamic pivot table creation with drag-and-drop UI.
  • Enables asynchronous data loading and handles large datasets efficiently.
  • Offers advanced filtering, sorting, and custom calculation capabilities.
Syncfusion logo

Prices from:

Loading...
Available in
Syncfusion Essential Studio UI Component SuiteLoading
Syncfusion Essential Studio EnterpriseLoading
Syncfusion WPF Pivot Grid product image
Syncfusion WPF Pivot Grid is a data analysis component that organizes and summarizes business data in a cross table format. It supports pivot table style reporting with features such as filtering, sorting, grouping, and summarizing, helping users explore large datasets from multiple perspectives inside WPF applications.

Dynamic Field List UI

The control provides a pivot table field list allowing end users to drag, filter, and sort fields at runtime to create customized pivot reports easily.

Asynchronous Data Loading

It performs long-running operations on background threads to keep the user interface responsive while loading and processing large data sets.

On-Demand and Virtual Scrolling

Enables loading large records quickly on demand and uses virtual scrolling to enhance performance when rendering extensive pivot grid cells.

Flexible Data Binding

Supports various data sources like DataTable, DataView, collections like IEnumerable, and SQL DataSets for binding, ensuring versatile integration options.

Comprehensive Summaries and Calculations

Includes support for 19 built-in summary types and 16 calculation types, along with user-defined calculated fields using custom formulas at runtime or programmatically.

Advanced Filtering and Sorting

Offers built-in header, Excel-like filtering, and multiple sorting options including custom and multi-column sorting for detailed data analysis.

Editing and Real-Time Updating

Allows users to edit pivot cell values at runtime and update data dynamically, reflecting changes instantly in totals and summaries.

Rich UI Customization

Provides customization of cell templates, conditional formatting, freezing headers, column resizing, and supports a variety of built-in themes and styles.

Export and Print Capabilities

Facilitates exporting pivot data to Excel, Word, PDF, and CSV formats along with printing support for detailed report distribution.

Globalization and Accessibility

Supports localization, right-to-left text layout, and is compatible with UI automation tools for enhanced accessibility and global use.

Product Compatibility

Review the details below to ensure this product is supported within your environment.

Component Type

  • .NET

.NET Version

  • .NET 10 LTS
  • .NET 9 STS
  • .NET 8 LTS
  • .NET 4.8 or earlier

.NET Platform

  • .NET WPF

IDE Support

  • Visual Studio