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
    Download Free Trial

    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 Consultation

    FlexPivot Key Features

    Smart and Intuitive Pivot Panel

    • Drag and Drop

      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.

    • 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), count and count distinct.

    • Filter and Slice Data

      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.

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

    Connect to a Microsoft SSAS cube

    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.

    Data Visualization

    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.

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

    Create Ranges and Bins

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

    Save and Load Data Views

    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 Desktop Demo

    ComponentOne Enterprise Free Trial

    Download

    ComponentOne Enterprise

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