FlexPivot

List of Services

    Excel-like pivot table and chart controls

    • Provides a pivot panel UI for pivot tables, charts, and dynamic views.
    • Import multiple data sources into multidimensional pivot tables, either online or from local OLAP cubes.
    • FlexGrid is the best .NET data grid chosen by developers and is extensible.
    • Desktop : WinForms, WPF
    • Web : ASP.NET MVC, Wijmo JavaScript
    Developer Forum (Technical Support) Developer Forum (Technical Support)

    Why Choose FlexPivot?

    Panel design similar to Excel

    It provides ease of use to customers with a design similar to Microsoft's Excel Pivot Table.

    Process millions of data points in milliseconds

    FlexPivot's powerful data engine enables fast data processing.

    Slice & Dice Table Format and Cube Data

    Provides deep business intelligence with a pivot UI that slices tabular and cube data to provide users with real-time information, insights, and results in seconds.

    Increase user productivity

    Built-in view save and load functionality reduces development time and improves end-user productivity.

    Connect directly to Microsoft's SSAS cubes

    You can connect to various data sources, such as MicroSoft SQLServer Analysis Services (SSAS), online, or local cubes.

    Data analysis without code

    Simply connect the C1FlexPivotPage component to a data source and you can use analysis tools, including a pivot panel and toolbar.

    Ask anything!

    Share your concerns and questions about ComponentOne with MESCIUS's expert team. We empathize with your concerns and are here to help.
    Online product consultation Developer Forum (Technical Support)

    FlexPivot Key Features

    Smart and intuitive pivot panel

    • Drag and Drop

      Users can drag fields to the "View" list, which displays rows, columns, values, and filters. The Excel-like panel design feels familiar to users.

    • 집계(Aggregate Multiple Values)

      The Pivot panel supports multiple value fields, allowing you to aggregate and visualize multiple columns per dimension, such as comparing units sold and total revenue. You can also use the same field multiple times, such as sum and count.

    • Pivot Slicer

      Provides buttons that users can click to filter data based on values and indicates the current filtering state.

    Data Summary & Display

    Aggregation and Summary

    Dynamically group and aggregate data. FlexPivotGrid is an extension of FlexGrid and supports automatic data binding for each cell in the grid, grouped rows and columns, summaries, column resizing, data filtering, and drill-down details.

    Conditional formatting

    You can apply conditional formatting at runtime using the built-in menu in the Pivot panel. Highlight high and low values by specifying text color, cell color, or text weight.

    Connecting data sources

    SQL Server & Excel Connection

    The WinForms PivotTable component provides its own OLAP engine that works with a variety of data sources, including SQL Server and Excel. It brings multiple data sources into a single application and presents data from online or local cubes, allowing users to drill down and analyze data more meaningfully. The Data Engine service allows you to leverage multiple data sources, including SQL Server, SQL-based RDMS servers, NOSQL, web services, and structured files.

    Connect to a Microsoft SSAS cube

    Build a complete front-end dashboard for your database using FlexPivot. Connect directly to Microsoft® SQL Server® Analysis Services (SSAS) cubes without going through a server. Users can create multidimensional pivot tables that slice and dice dimensions, measures, and key performance indicators (KPIs) in OLAP cubes.

    Data visualization

    Uncover new insights and trends by converting the same pivot table view into a chart! FlexPivotChart is an extension of FlexChart and supports multiple chart types, including column, bar, area, scatter, pie, tooltip, legend, and hierarchical axes.

    Ask anything!

    Share your concerns and questions about ComponentOne with MESCIUS's expert team. We empathize with your concerns and are here to help.
    Online product consultation Developer Forum (Technical Support)
    Analyze and manage millions of records

    Analyze and process up to hundreds of millions of records in an instant. ComponentOne FlexPivot can handle extremely large data sets thanks to its powerful data engine, which stores data in memory-mapped files using column-oriented technology.

    Asynchronous processing

    Provides a progress bar and background tasks. You can also defer updates to the pivot panel to improve performance.

    Export

    Export to Excel (XLSX) and save formatting information along with the data. The saved file includes most formatting information, including row and column dimensions, fonts, colors, formats, and cell alignment.

    Creating Ranges & Intervals

    Create numeric, date, and string-based ranges or "bins" for advanced grouping scenarios.

    View, save, and load data

    You can save views for quick analysis of your application's performance. The all-in-one Pivot Page component has a built-in save function.

    Custom Pivot UI

    You can customize the FlexPivotPage control or build a completely custom pivot UI using separate grid, panel, and chart components.

    FlexPivot Add-on

    FlexPivot Table Demo

    Explore all the features and showcase demos of FlexPivot using the Control Explorer application for .NET Framework or .NET 6 !

    Download the Desktop Demo Explorer

    ComponentOne Enterprise Free Trial

    Download

    ComponentOne Enterprise

    Expand your development reach across all .NET platforms with ComponentOne Enterprise.

    Desktop

    WinForms

    WinUI

    WPF

    UWP

    Mobile

    MAUIXamarin Forms

    Xamarin iOS

    Xamarin Android

    Legacy

    ActiveX

    ASP.NET Web Forms

    Silverlight

    LightSwitch

    Data Services

    Web API

    .NET Data Services

    Web

    ASP.NET MVC

    ASP.NET Core MVC

    Blazor