The jQWidgets Pivot Grid for jQuery is a lightweight and powerful data visualization widget written entirely in JavaScript. It offers many advanced features and is highly customizable to different needs.
The jquery pivot grid allows visualization of multi-dimensional data and hierarchical data structures. It supports multiple different aggregation functions and developers can also provide user-defined aggregations. The pivot grid for jQuery also ships with a pivot table designer widget. The pivot table designer allows you to visually configure the pivot columns, rows, aggregated values and multiple different settings. You can also configure pivot rows and columns text alignment settings and various text formatting options on the pivot cells. The jQuery pivot grid and the pivot designer also allow the user to configure pivot table filters both programmatically and visually using drag and drop operations and filter selection options. You can use the PivotGrid widget to add interactive pivot tables to your website, build custom dashboards, or use it in your mobile applications. The pivot grid widget offers excellent cross-browser compatibility and works well with both desktop and mobile browsers.

Basic concepts

Before you start with the Pivot Grid widget, you should be familiar with pivot tables and understand when to use regular data grids to display table data, and when to switch to the pivot grid and pivot tables. The following article is a good entry-level introduction to pivot tables: Wikipedia: Pivot tables

Generally the pivot grid will contain the following elements:
  • Pivot Rows - the unique values of the source columns which form the rows hierarchy.
  • Pivot Columns - the unique values of the source columns which form the rows hierarchy
  • Pivot Values - the aggregation funciton headers. They can be displayed below the columns or on the right side of the rows.
  • Pivot Cells - each pivot cell contains the aggregated value for the respective row, column and aggregation function.
jqxPivotGrid supports Compact and traditional OLAP style. The benefits of the compact style visualization are that it uses less space and you can see subtotals because. The rows that form the pivot table are rendred in a tree-like structure.

Compact style rendering

OLAP style rendering

With our pivot grid, you can conditionally format any cell.

The Pivot Grid allows you to display summary fields in order to make quick comparisons