• 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: WinForms, WPF, ASP.NET MVC and JavaScript.

All-in-One, Code-Free Data Analysis

  • Just connect the all-in-one page component to a data source and you have a complete analytical tool including the pivot panel, grid, chart and a toolbar.
  • Dynamically create summarized views by dragging fields into the row, column, and value lists.
  • The UI is modeled after Microsoft Excel® so it’s very easy for users to understand.

Group and Aggregate Data Instantaneously

  • FlexPivot enables users to group and aggregate data across the top or down the side of the grid.
  • Analyze against multiple measures and dimensions enabling users to compare totals side by side.
  • The WPF pivotgrid automatically calculates subtotals grand totals for each slice of your data.
  • At run-time or in code, specify how to aggregate the data such as sum, count, average.
  • Create numeric, date and string-based ranges for advanced grouping scenarios.

Filter and Highlight Data Dynamically

  • Enable users to filter data based on some conditions using value and range-based filters.
  • Users can simply right-click on the fields they would like to filter and select Field Settings.
  • Filter data based on multiple values while also indicating the current filtering state.
  • Highlight values with conditional formatting by specifying percentage-based thresholds like top 10% or bottom 10%.

Work with Multiple Data Sources

  • FlexPivot/OLAP provides its 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 or report.
  • Correlate and report on multiple data sources throughout an enterprise.
  • Deliver data from online or local cubes that users can drill down and parse more meaningfully.
  • The controls also support standard .NET data binding and work well in MVVM scenarios.

Microsoft SSAS Cubes Support

  • Connect directly to your Microsoft® SQL Server® Analysis Services (SSAS) cube without any server go-between.
  • There's no need for the server-side API if you already have SSAS cubes in place!
  • Build a complete front-end dashboard for your database using FlexPivot/OLAP while writing just a couple lines of code.
  • 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 Trends with the Pivot Chart

  • Convey the same pivot table view in a chart to discover new insights and trends.
  • Summarize data in multiple chart types, including column, bar, area, line, scatter, and pie
  • Users can customize the charts with tooltips, stacking, and color palette selection.
  • Convey the view structure with hierarchical axes.

Print, Save and Export to Excel

  • Harness the real power and usefulness of FlexPivot/OLAP with its ability to save and load views.
  • Configure your application so the user can save common views for future analysis.
  • The pivot table information can be exported to CSV, HTML, and text formats.
  • The entire pivot table and charts can be printed directly from a built-in print preview dialog.
  • Export or copy/paste the grid data to Microsoft Excel for additional analysis or to further customize the report.