WPF Pivot Grid - Syncfusion WPF UI Controls

The WPF pivot grid control organizes and summarizes business data and displays the result in a cross-table format.

Features and Benefits

High performance

• Asynchronous loading - Ability to perform long-running operations asynchronously on a background thread. This allows end users to access other UI controls without distraction.
• On-demand loading - The control can load a large set of records on demand in little time.
• Virtual scrolling - It means a value only updates in the respective pivot grid view when the end user releases the scroll thumb.

Data binding

The WPF Pivot Grid control simulates the pivot table feature of Excel. The data source for the control should be either a DataTable, DataView, DataSet from SQL databases or collections like IEnumerable, ICollection, IList, List and ArrayList.

Pivot table field list and group fields

The WPF Pivot Table field list and Group fields are automatically populated with fields from the bound data source. They later allow end users to drag fields, filter and sort them, and create a pivot report at runtime.

Drill down and drill up

Drill down (expand) and drill up (collapse) to visualize the pivot information in both abstract and detailed views.

Defer update

Refresh the control only on demand and not during every UI interaction.

Editing and updating

• Editing in WPF Pivot Grid - Edit values at runtime, thereby updating the total cell simultaneously.
• Updating in WPF Pivot Grid - Update values in real time by pushing the live data and refreshing the control whenever it’s required.

Filtering

Built-in header and Excel-like filter UIs with advanced filtering options to easily filter and view data. It is also possible to filter programmatically. It is also possible to filter programmatically.

• Header filtering in WPF Pivot Grid - Display only selective values for a field through either UI or code-behind.
• Excel-like filtering in WPF Pivot Grid - Advanced options are available to filter column and row headers either based on label text or grand-total value.

Sorting

Order rows and columns, either based on labels or values.

• Header sorting in WPF Pivot Grid - Order the column and row header text either in ascending or descending order.
• Custom sorting in WPF Pivot Grid - Order the column and row header text based on the custom comparer defined by user.
• Column sorting in WPF Pivot Grid - Order the column values either in ascending or descending order by clicking the desired column header.
• Multi-column sorting in WPF Pivot Grid - Order one or more columns either in ascending or descending order by holding the Ctrl key and clicking the column headers.

Summaries and calculations

• Summaries - Provides extensive support for you to define your own custom summaries for the pivot item values using a built-in dialog at runtime as well as programmatically. It also supports 19 other built-in summary types to customize the summaries.
• Calculations - Along with 16 built-in calculation types, there is also extensive support to insert user-defined calculated fields using a custom formula, either dynamically at runtime or programmatically.

Calculated field

The calculated field, otherwise known as unbound field generates unique field with our own calculated value by executing a simple user-defined formula.

Expression field

Expression field generates data by executing user-defined expressions. The generated data is specific to a few field(s) from the underlying data source.

Drill through

It easily obtains a list of raw items for a particular value cell or summary cell.

Cell template

Format the column header, row header, summary cell, and value cell of the control.

Conditional formatting

Define conditions that, when met, format values and summary cells font, color, and border settings.

Number formatting and date formatting

Number formatting and date formatting help to transform the appearance of the actual cell value.

Visualization

Users can visualize the control either as a flat grid or a pivot table similar to Excel. Users can also position summaries at the top.

• Normal layout - This looks like the pivot table in earlier Excel versions, allowing the end user to pivot rows, columns, and calculations.
• Flat grid - Users can customize the pivot grid to look like a flat grid. It allows users to pivot only rows and calculations.
• Summary layout - The summary layout easily switches the summary position to either the top or bottom beside each field in the control.

Totals

Subtotals and grand totals are calculated automatically by the pivot engine inside the control and displayed in the pivot grid. This helps users make decision based on the totals. Also, users can show or hide subtotals and grand totals for rows and columns.

Column and row

• Hyperlink - User can retrieve information about a particular cell on hyperlink cell click. It later allows you to perform custom operations programmatically.
• Context menu - There is a UI option to expand or collapse a header to a certain extent.
• Tooltip - Provides basic information about a cell while hovering the mouse pointer over it.
• Column resizing - Easily resize each column’s width through a simple drag operation at runtime.
• Freeze header - Users can freeze row and column headers while performing scroll operations to have a precise view of the content.
• Selection - Select a range of value cells.

Save and load reports

Settings in the WPF Pivot Grid control can be serialized to an XML format and loaded back through the built-in deserialization options.

Exporting and printing

The WPF Pivot Grid control has a rich set of options available for exporting data to Excel, Word, PDF, and CSV, and printing the same. Several options are also provided to customize the exporting and printing operations.

Related links

Learn More about WPF Pivot Grid

Download Free Trial

Pricing

View Demos

Samples

Community Forums

Documentation

Knowledge base

Suggest a Feature

About Syncfusion WPF Controls

Syncfusion's WPF controls library is the only suite that you will ever need to build an application since it contains over 95 high-performance, lightweight, modular, and responsive UI controls in a single package. In addition to Pivot Grid, we provide popular WPF Controls such as WPF DataGrid, WPF Scheduler, WPF Diagram, WPF Docking, and WPF PDF Viewer.

About Syncfusion

Founded in 2001 and headquartered in Research Triangle Park, N.C., Syncfusion has more than 29,000 customers and more than 1 million users, including large financial institutions, Fortune 500 companies, and global IT consultancies.

Today we provide 1800+ controls and frameworks for web (Blazor, ASP.NET Core, ASP.NET MVC, ASP.NET WebForms, JavaScript, Angular, React, Vue, and Flutter), mobile (Xamarin, Flutter, UWP and JavaScript), and desktop development (WinForms, WPF, WinUI, UWP, Flutter, and .NET MAUI). We provide ready-to deploy enterprise software for dashboards, reports, data integration, and big data processing. Many customers have saved millions in licensing fees by deploying our software.

sales@syncfusion.com | www.syncfusion.com | Toll Free: 1-888-9 DOTNET