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.

OLAP Features

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

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