OLAP Pivot Controls

High-Speed Excel-like Pivot Table and Charts

Create Excel-like, web-based pivot tables in JavaScript with Wijmo’s OLAP module. Process and aggregate thousands of rows in milliseconds with no server-side dependencies. The smart pivot panel interprets data types and intelligently places fields in an intuitive, modern UI.

*The OLAP module is included in Wijmo Enterprise.

Already purchased Wijmo? Download it here.


Drag and drop pivot fields in the smart PivotPanel

  • Excel-like panel design feels familiar to users
  • Allows users to drag fields into “view” lists representing row, column, value, and filter
  • Save time with smart data interpretation—panel intelligently places fields
  • Use same field multiple times in Values, eg: Sales (total) and Sales (count)
  • Asynchronous processing provides progress bar and background work
  • Save user’s time with built-in save/load of views
  • Read more about creating basic pivot tables
  • See how to answer recurring questions with pre-defined views

Drag and drop pivot fields in the smart PivotPanel

Display Excel-like data summaries in PivotGrid

  • Manage large data sets easily with collapsible rows and column groups
  • Drill down into the data with the custom context menu
  • Export the grid to XLSX files
  • Grid extends and inherits FlexGrid, including custom cell feature
  • Extend your grid’s formatting with logical grouping for multiple date types
  • Group and manage data with subtotals
  • Export the grid to XLSX files. Read more about Excel export
  • Grid extends and inherits FlexGrid, including custom cell feature. Read more about customizing the UI

Display Excel-like data summaries in PivotGrid

Visualize large data sets with PivotChart

  • Summarize data in multiple chart types, including column, bar, area, line, scatter, and pie
  • Convey the view structure with hierarchical axes
  • Contains both FlexChart and FlexPie and inherits from those Wijmo controls

Visualize large data sets with PivotChart

Server-Side OLAP Support

Wijmo’s Pivot controls were created for analyzing datasets on the client. Our client-side OLAP engine can handle relatively large amounts of data (in the order of hundreds of thousands of records), but it requires the raw data to be downloaded to the client, and that makes it impractical to analyze really large datasets (millions of records).

We have added optional server-side support to our OLAP controls. You can now use a URL in the itemSource property that will instruct the OLAP controls to query a Web API on the server instead of analyzing an array on the client. The server-side engine is part of our ASP.NET MVC product line and must be installed and licensed separately. We recommend purchasing Ultimate so that you have both server and client side components for our OLAP controls.

Try Server-Side OLAP Sample

First Class Angular 1 and 2 Support

AngularJS is one of the most popular and powerful JavaScript application frameworks today. With the development of Angular 2, it continues to set the direction of the next Web. For this reason, we ship and maintain AngularJS directives for all of our controls, and use it in most of our samples. Of course, you can also use Wijmo with other frameworks. We provide official support for KnockoutJS and will consider others in the future.

Angular JS