JavaScript Pivot Table - Powerful Data Summarizing and Reporting

Improve your business intelligence by visualizing your complex data with our high-speed JavaScript/HTML5 Pivot component.

It helps you to summarize large data sets in a convenient way.

Key Features

• Pure JavaScript library, easily integrated with any server side
• No 3rd party dependencies
• 5 steps and you embed js pivot grid into your app
• Extensive API to configure it for any needs
• Fast loading of large datasets
• Cross-browser and cross-platform support

• Convenient filtering and sorting
• Custom and preset data operations
• Customizable look and feel
• Full localization of the interface
• Export to Excel and CSV
• More functionality is coming, we accept feature requests

How to Start with dhtmlxPivot

Build your first JavaScript Pivot table with 5 simple steps:

1 Create an HTML file

2 Include the Pivot js and css source files in the header

3 Add a container with an id - e.g. “container”

4 Initialize the widget with the dhx.Pivot object constructor

5 Specify Pivot structure, fields, and other configuration properties you need

Why dhtmlxPivot?

Our JavaScript pivot grid component provides fast performance with large data sets. It's an important benefit for business applications where you need to work with hundreds and thousands of records. DHX Pivot renders considerable amount of data equally well in all web browsers.

The Pivot appearance is fully configurable. All the elements of JavaScript/HTML5 Pivot table layout can be adjusted according to your needs. There is a set of attributes that you can use to modify the look and feel of your table in the blink of an eye.

Since Pivot tables are intended to work with large amount of data, the possibility to load data into your table easily is a must. Our JavaScript pivot grid component supports data loading in the JSON format, which is the simplest and most convenient way.

The end users may want to have labels and elements of a web pivot table in a different language. You can make use of the related Pivot API to fully localize its interface. Thus the component will be displayed in the necessary language. And even may show currency symbols specific to the localization you choose.

Due to simple initialization, which takes just a few steps, DHX Pivot grid has an extremely short learning curvethat significantly increases the development speed.

Besides 4 preset types of data operations (sum, max, min, and count), you can add your own operations, which show how flexible our javascript pivot table is. Pivot table contains the footer, where the resulting values of operations are displayed.

The sorting feature is available in dhtmlxPivot. A single click on header of the row, and ascending/descending sorting icons will appear.

You can apply the filters to display the selective data, narrow or extend your data query. This can be achieved by either pre-defined filters (before data aggregation) or on-the-fly by using UI elements.

In your web pivot table you can style the cells based on specific conditions. As an example, you can highlight min and max values of the cells by different colors. Besides, you can add any custom content to the cell that you need like checkboxes and other elements.

You can export the pivot grid in an excel file using our online export service or get your own export module. The exported documents will include styles and templates you have added to dhtmlxPivot.