<
Explore DHTMLX Pivot 2.0: Overhauled JS Pivot Table with Superior Performance, Frozen and Collapsible Columns, and New Total Option
JavaScript

JavaScript Pivot Table - Rapid and 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.

Open a demo on desktop
With DHTMLX Pivot, you get a user-friendly table to manage large data sets quickly and conveniently.
Capterra Shortlist 2024
GetApp Category Leaders 2024
Software Advice Front Runners 2024
Best Meets Requirements
High Performer EMEA
Users Most Likely To Recommend
Easiest to Use

Upgrade Your Data Analysis App with DHTMLX Pivot

Convenient data management
Add-on
Styling options
Performing math methods for data aggregation
DHTMLX Pivot provides predefined methods for performing basic and more complex math operations on input data. They help to find the minimum or the largest values, calculate the average, or display the sum of the selected data. Some of the methods can be applied both for text and numeric values, e.g. countunique for counting the number of unique values in a certain list.
Performing math methods for data aggregation
Generating total values
Our JavaScript pivot table allows generating a row with total values in its footer. Moreover, you can add an extra column with totals and help end-users swiftly compare individual row with column total values, getting a more comprehensive data summary.
Generating total values
User-friendly operations with columns and rows
DHTMLX Pivot allows for intuitive data manipulation and analysis. Sorting and filtering options are readily accessible, enabling end-users to focus on specific subsets of data. It's possible to freeze columns and rows and collapse/expand specific columns and rows thus making it easier to work with large data sets.
User-friendly operations with columns and rows
Performing math methods for data aggregation
Excel export module
By default, you can export your pivot table to the XLSX and CSV formats using online export services. Besides, you have an option to get your own export module and install it on your server. We also provide all updates and fixes to the export service along with free annual support.
Excel export module
Excel export module
Adjustable height and width
You can configure the Pivot table appearance via the widget API. It allows you to easily manipulate the width of columns and rows, header and footer. You can set up auto-size to content and define the minimum width value for all columns.
Adjustable height and width
Customizable built-in theme
DHTMLX Pivot JavaScript component comes with a built-in Material theme. However, you can customize the default theme and change the appearance of the pivot table by applying the corresponding CSS variables. The following example shows how to modify the background, icon, and border colors.
Customizable built-in theme
Custom marks for cells
The Pivot API enables you to mark data table cells with the required values. Thus, for example, you can set the widget to highlight cells with min and max values as well as cells with values that are non-integer and greater than 2.
Custom marks for cells
Adjustable height and width

How to Start with DHTMLX Pivot

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

Key Features of the JavaScript/HTML5 Pivot Component

Pure JavaScript library, easily integrated with any server side
No 3rd party dependencies
Extensive API to configure it for any needs
Cross-browser and cross-platform support
Convenient filtering and sorting
Custom and preset data operations
Customizable look and feel
Export to Excel and CSV
Collapsible columns
Expanding and collapsing rows
Setting limits on loaded data
Get a More Fast and Powerful JS Pivot Grid
DHTMLX Pivot 2.0 is a renewed widget with the codebase overhaul, improved performance, and new features. You can switch from the previous version using the converter for data migration.

Why Choose DHTMLX Pivot?

Lightning-fast data rendering
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. DHTMLX Pivot renders a considerable amount of data equally well in all web browsers.
Configurable UI
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.
Flexible customization
DHTMLX Pivot supports styling via CSS variables. 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.
Support for Angular, React, and Vue.js
The JavaScript Pivot component can be integrated with the most widely used client-side frameworks. Integration with Angular, React, and Vue.js is smooth and requires just a few quick steps described in our guides.
Fast learning and initialization
Due to simple initialization, which takes just a few steps, the DHTMLX Pivot grid has an extremely short learning curve that significantly increases the development speed.
Get started for free
Download the DHTMLX Pivot trial version and test it completely free of charge for 30 days taking advantage of our email technical support.

DHTMLX Pivot Licensing

Individual
Total: $299
Commercial
Total: $499
Enterprise
Total: $749
Ultimate
Total: $1499
License Terms Read License Agreement Read License Agreement Read License Agreement Read License Agreement
Developers 1 5 20
Projects 1 1 5
Use in SaaS (unlimited end-users)
Perpetual distribution rights
Support Plan
Standard Premium Premium Ultimate
Time Period 1 year 1 year 1 year 1 year
Updates Major, minor, and maintenance updates Major, minor, and maintenance updates Major, minor, and maintenance updates
Major, minor, and maintenance updates
Priority queue for bug fixing
Support requests 10 30 50
Response time 72h 48h 48h 24h
Personal Account Manager
Functionality
PRO PRO PRO + 1 add-on PRO + 1 add-on
Online export to Excel Free Free Free Free
Free local Excel export module
Individual
$299
License Terms Read License Agreement
Developers 1
Projects 1
Use in SaaS (unlimited end-users)
Perpetual distribution rights
Support Plan
Standard
Time Period 1 year
Updates Major, minor, and maintenance updates
Support requests 10
Response time 72h
Personal Account Manager
Functionality
PRO
Online export to Excel Free
Free local Excel export module
Commercial
$499
License Terms Read License Agreement
Developers 5
Projects 1
Use in SaaS (unlimited end-users)
Perpetual distribution rights
Support Plan
Premium
Time Period 1 year
Updates Major, minor, and maintenance updates
Support requests 30
Response time 48h
Personal Account Manager
Functionality
PRO
Online export to Excel Free
Free local Excel export module
Enterprise
$749
License Terms Read License Agreement
Developers 20
Projects 5
Use in SaaS (unlimited end-users)
Perpetual distribution rights
Support Plan
Premium
Time Period 1 year
Updates Major, minor, and maintenance updates
Support requests 50
Response time 48h
Personal Account Manager
Functionality
PRO + 1 add-on
Online export to Excel Free
Free local Excel export module
Ultimate
$1499
License Terms Read License Agreement
Developers
Projects
Use in SaaS (unlimited end-users)
Perpetual distribution rights
Support Plan
Ultimate
Time Period 1 year
Updates
Major, minor, and maintenance updates
Priority queue for bug fixing
Support requests
Response time 24h
Personal Account Manager
Functionality
PRO + 1 add-on
Online export to Excel Free
Free local Excel export module

Unlock up to 65% Savings with DHTMLX Bundles

Documentation
Consult the documentation
Explore the Pivot documentation with detailed API descriptions and step-by-step guides and tutorials. It also provides instructions for seamlessly integrating the pure JavaScript component with Angular, React, and Vue.js frameworks.
Samples
Discover code snippets
Use our flexible code snippet tool to create and configure pivot data tables online. Explore various code possibilities and share customized examples with your team or DHTMLX support.
Free trial
Download Pivot free trial
Assess the features of DHTMLX Pivot by downloading the free 30-day trial version. It includes the latest updates and provides access to the official technical support.
Official tech support
Learn about technical support
Read about the available methods for obtaining technical or licensing support. The DHTMLX team assists both proprietary license holders and trial users.
Community forum
Use DHTMLX forum
Discover solutions in the knowledge base shared by DHTMLX users and benefit from the experiences of skilled developers. We monitor discussions and address frequently asked questions.
Blog
Keep up with Pivot updates
Dive into the DHTMLX blog, a comprehensive resource that provides the latest updates on the JavaScript Pivot component, detailed feature descriptions, helpful tips, and technical tutorials.

Latest Blog Posts

DHTMLX Pivot 2.0: Overhauled JS Pivot Table with Superior Performance, Frozen and Collapsible Columns, New Total Option, and Much More
Data Analysis with DHTMLX JavaScript Libraries
Most Frequent Questions from Developers about Our JavaScript Pivot Table
What's new
Discover the recently launched DHTMLX Pivot versions, fresh developer guides, and tutorials with code snippets and practical tips from our tech team.
Operate with large data sets quickly and conveniently with DHTMLX Pivot
Download the Pivot trial version and evaluate it free of

charge for 30 days getting assistance from the official support team.
NO credit card required
Send
a Question