Cross-Platform .NET Pivot Tables and Charts

Create dynamic pivot tables like Microsoft Excel with ComponentOne FlexPivot. FlexPivot includes .NET pivot grids, charts and a pivot panel UI that allows users to create dynamic views.

  • Connect to multiple data sources including SSAS cubes
  • Process and aggregate millions of rows in milliseconds
  • Get the same pivot table UI across multiple platforms: WinForms, WPF, ASP.NET and JavaScript

FlexPivot is only available in Studio Enterprise.

Download Free Trial (2022v1)

Why Choose FlexPivot?

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.

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.

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 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 SQLServer Analysis Services (SSAS), online or local cubes, or any data table or collection of business objects.

Cross-Platform Data Analysis

Get the same pivot table UI across multiple desktop and web platforms: WinFormsWPFASP.NET MVC, and JavaScript.

.NET Pivot Table Key Features

All-in-one, Code-Free Data Analysis

.NET Pivot Table Component

Just connect the all-in-one C1FlexPivotPage component to a data source and you have a complete analytical tool including the pivot panel, grid, chart and a toolbar. The UI is modeled after Microsoft Excel® so it’s very easy for users to understand.

Smart and Intuitive Pivot Panel

 .NET Pivot Panel

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.

 .NET Pivot Table Multiple Values

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).

NET Pivot Table Filtering

Filter and Slice Data Dynamically

Enable users to filter data based on some conditions using value and range-based filters. Filter data based on multiple values or by some formula such as TopN to find the top or bottom data records. The separate slicer control also provides a quick way to edit filters at run-time. Supported in WinForms and ASP.NET MVC.

Display Data Summaries in a Pivot Grid

.NET Pivot Grid Control

Aggregate and Summarize Data

Dynamically group and aggregate data across the top or down the side of the .NET pivot grid. The PivotGrid 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.

Connect to Multiple Data Sources

.NET Pivot Table Data Connections

Connect to SQL Server and Excel

The .NET pivot table components provide their own OLAP engine that works on top of a wide range of data sources including SQL Server and Excel. 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. With Data Engine Services you can use multiple data sources including SQL Server, SQL-based RDMS servers, NOSQL, web services and structured files.

.NET Pivot Table SSAS Cubes

Connect to Microsoft SSAS Cubes

Build a complete front-end dashboard for your database using FlexPivot while writing just a couple lines of code. Connect directly to your Microsoft® SQL Server® Analysis Services (SSAS) cube without any server go-between. Users can build a multidimensional pivot table that slices and dices the dimensions, measures, and Key Performance Indicators (KPIs) present in the OLAP cube.

Visualize Aggregated Data with PivotChart

.NET Pivot Chart Control

Convey the same pivot table view in a chart to discover new insights and trends. The PivotChart 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 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.

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.

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.

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.

Export Pivot Data to Excel

Export the .NET 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.

Cross-Platform Data Analysis

Get the same pivot table UI across multiple desktop and web platforms: WinForms, WPF, ASP.NET MVC and JavaScript.

.NET Pivot Table Supported Platforms

WinForms Pivot Table

Just drop the C1FlexPivotPage component to your form, connect to a data source, and you have an entire pivot table application! FlexPivot for WinForms emphasizes and lets you take full advantage of the code-free benefits the platform offers.

WPF Pivot Table

Pivot and slice your data in a modern looking desktop pivot table control. FlexPivot for WPF boasts a sleek modern style with easily customizable brushes and UI for building that perfect customized analytical application.

ASP.NET MVC Pivot Table

With ComponentOne OLAP for ASP.NET MVC, get the same pivot table functionality in your browser. The web version has some unique features like outline view. It supports ASP.NET MVC and ASP.NET Core.

.NET Pivot Table Demos

ComponentOne Demo Explorer

Desktop Demo Explorer

All of our WinForms and 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+.

ASP.NET MVC OLAP Explorer

Explore key features for ComponentOne OLAP for ASP.NET MVC. See demos for the .NET pivot grid summaries, remote data binding, SSAS Cube data source and more.

ComponentOne Customer Feedback and Awards

"Prompt responses, quality feedback, and help with code examples. Fantastic service!"

RICHARD HERBERT

"Excellent product with good support"

MIKE WEBSTER

"I am very appreciative of the effort your entire team gave to make this transaction happen. Thank you for your efforts!"

SAM COLE

ComponentSource #2 Publisher 2022 Award ComponentSource #3 Product 2022 Award