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 higly 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:

Getting started

The pivot grid is entirely agnostic to the data source. You can use any data source to retrieve data using the jqxDataAdapter component and then pass it to the jqxPivot adapter which handles all aggregations. Finally, the pivot grid displays the aggregated data prepared by the jqxPivot adapter. Below is the step by step process:

Step 1 - Create a HTML file and include the required scripts/format

Step 2 - Create some sample data or use an existing data set

Step 3 - Create a data adapter to load the data from your data set

Step 4 - Create a pivot table data source with the desired pivot columns, pivot rows and pivot values

Step 5 - Inititialize the pivot grid and pass the pivot adapter as a source

Below is the pivot grid created with the sample data and settings

Pivot Grid Features

The jQuery PivotGrid Widget supports the following features: