Skip to main content Skip to footer

High-Speed WPF Pivot Table Controls

Create dynamic pivot tables like Microsoft Excel and aggregate millions of rows of data in milliseconds with ComponentOne FlexPivot.

  • Get WPF pivot grids, charts and a pivot panel UI that allows users to create dynamic views
  • Pull multiple data sources into a single, multi-dimensional pivot table from online or local OLAP cubes
  • The smart pivot panel interprets data types and places fields in an intuitive, modern UI

FlexPivot is only available in Studio Enterprise.


Why Choose FlexPivot for WPF?

Excel-Like Design

Familiar Excel-Like Panel Design

The easy-to-use controls are modeled after Microsoft Excel® Pivot Tables, so they're powerful and familiar for all users.

Flex Pivot Slice

Slice and Dice Tabular and Cube Data

Deliver in-depth business intelligence with a pivot UI that slices and dices your tabular and cube data to give users real-time information, insights, and results in seconds.

Record Guage

Process Millions of Records in Milliseconds

Built on a super-charged data engine, FlexPivot offers a lightning-fast data engine that will give your users more power, speed, and reach than ever before.

Increase Productivity

Increase User Productivity

Includes built-in save and load of views, which saves development time and increases productivity by giving more power to the end-user.

Connect Directly to Microsoft SSAS Cubes

Connect to various data sources such as Microsoft SQL Server Analysis Services (SSAS), online or local cubes, or any data table or collection of business objects.

More than Gantt Chart

All-in-One, Code-Free Data Analysis

Just connect the all-in-one FlexPivotPage component to a data source and you have a complete analytical tool including the pivot panel, grid, chart and a toolbar.

WPF Pivot Table Key Features

Smart and Intuitive Pivot Panel

WPF Pivot Table Panel UI

Drag and Drop Pivot Fields

Allow users to drag fields into "view" lists representing row, column, value, and filter. The Excel-like panel design feels familiar to users. The panel is "smart" too because it can intelligently place fields based on their data type when you double-click them. Users may defer updates for optimal performance.

Aggregate Multiple Values

The pivot panel supports multiple value fields so that you may aggregate and visualize multiple columns per dimension, such as comparing units sold and total revenue. You can even use the same field multiple times, such as total (sum) and total (count).

Display Data Summaries in a WPF Pivot Grid

WPF Pivot Table Summaries

Aggregate and Summarize Data

Dynamically group and aggregate data across the top or down the side of the WPF pivot grid. The FlexPivotGrid is an extension of FlexGrid and supports automatic data binding, grouped row and columns, summaries, resizing columns, filtering data and drill-down details for each cell in the grid.

Conditional Formatting

Users can apply conditional formatting at runtime using the built-in menus from the pivot panel. Highlight high and low values by coloring the text color, cell color or text weight. For example, highlight values below zero, or highlight the top 10% of values.

Create Ranges and Bins

Create numeric, date and string-based ranges, or "bins", for advanced grouping scenarios. For example, aggregate all values that fall between 0-100 in a single cell.

Connect to Microsoft SSAS Cubes

WPF Pivot Table SSAS Cubes

Connect to Microsoft SSAS Cubes

Pull multiple data sources into a single application and deliver data from online or local cubes that users can drill down and parse more meaningfully. Connect directly to your Microsoft® SQL Server® Analysis Services (SSAS) cube without any server go-between. Users can build a multidimensional WPF pivot table that slices and dices the dimensions, measures, and Key Performance Indicators (KPIs) present in the OLAP cube.

Visualize Aggregated Data with a Pivot Chart

Visualize Aggregated Data with a Pivot Chart

Virtual Mode

Convey the same WPF pivot table view in a chart to discover new insights and trends. The FlexPivotChart is an extension of FlexChart and supports multiple chart types, like column, bar, area, scatter, and pie, tooltips, legends and hierarchical axes.

Additional Features

Analyze Records

Analyze and Manage Millions of Records

Analyze and handle up to hundreds of millions of records in a fraction of a second. ComponentOne FlexPivot can handle very large data sets thanks to its powerful data engine that stores data in memory-mapped files using column-oriented technology.

Asynchronous Processing

Asynchronous Processing

Asynchronous processing provides a progress bar and background work. Users may also defer updates to the pivot panel to improve performance. 

Connect to SQL Server and Excel

The WPF pivot table components provide their own OLAP engine that works on top of multiple data sources including SQL Server, SQL-based RDMS servers, NOSQL, web services, structured files and Excel.

Save And Load

Save and Load Data Views

Allow users to save their views for quick analysis on future runs of the application. The all-in-one pivot page component has built-in saving functionality.

Custom Pivot UI

Custom Pivot UI

You can customize the FlexPivotPage control, or use the separate grid, panel and chart components to build a completely custom pivot UI. For example, add a ribbon menu and docking tabs. Check out the FlexPivot samples to see how.

Import & Export to Excel

Export Pivot Data to Excel

Export the WPF pivot table to Excel (XLSX) and save the formatting information in addition to the data. The saved files will include most formatting information including row and column dimensions, fonts, colors, formats, and cell alignment.

WPF Pivot Table Demos

Desktop Demo Explorer

All of our WPF demos are included in a single downloadable desktop explorer. Explore every feature and showcase demos for FlexPivot using the Control Explorer application for .NET Framework or .NET 6+.