< Meet the updated dhtmlxPivot 1.4 with a flat mode and export to CSV

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.

Live Demo

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

dhtmlxPivot Release History

August 10
2017
1.0
September 5
2017
1.1
November 2
2017
1.2
July 10
2018
1.3
August 8
2018
1.3.1
October 25
2018
1.3.2
January 10
2019
1.3.3
September 12
2019
1.4
Year
2020
2.0

Check our product's roadmap for future updates.

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 curve that 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.

What's new in dhtmlxPivot

The latest version of dhtmlxPivot is 1.4. Read the release notes. Here are the highlights of this update:
Flat Mode
Flat Mode
Dropdown Selectors
Dropdown Selectors
Interested in Pivot roadmap? Learn more and vote

dhtmlxPivot Licensing

Commercial Enterprise Ultimate
License Terms
Commercial
Enterprise
Ultimate
Developers
Commercial
5
Enterprise
20
Ultimate
Projects
Commercial
1
Enterprise
5
Ultimate
SaaS
Commercial
Enterprise
Ultimate
Perpetual distribution rights
Commercial
Enterprise
Ultimate
Support Plan
Commercial
Standard Support
Enterprise
Premium Support
Ultimate
Ultimate Support
Time Period
Commercial
1 year
Enterprise
1 year
Ultimate
1 year
Updates
Commercial
Minor & major updates
Bug fixes
Enterprise
Minor & major updates
Bug fixes
Ultimate
Minor & major updates
Bug fixes
Emergency bug fixes
Tickets
Commercial
10
Enterprise
30
Ultimate
Response Time
Commercial
72h
Enterprise
48h
Ultimate
24h
Personal Acccount Manager
Commercial
Enterprise
Ultimate
Functionality
Commercial
Professional
Enterprise
Professional
Ultimate
Professional
Online export to Excel
Commercial
Free
Enterprise
Free
Ultimate
Free
Free local export module to Excel
Commercial
Enterprise
Ultimate
dhtmlx bundles
Want to get more and save money?

Support & Learning Resources

We provide comprehensive documentation with technical samples. Moreover, our dedicated support team is fast and qualified. Find the suitable way to get support:

What Customers Say