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.

Upgrade Your Data Analysis App with DHTMLX Pivot

Convenient data management

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

Add-on

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.

Styling options

Custom HTML templates for cells The latest DHTMLX Pivot update introduces enhanced customization with templates, enabling developers to apply custom HTML content in header and body cells. Additionally, you can dynamically modify the table configuration using predefined templates for greater flexibility. 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. 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.

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
• Fast loading of large datasets
• Cross-browser and cross-platform support
• Convenient filtering and sorting
• Custom and preset data operations
• Customizable look and feel
• Local-dependent formatting
• Export to Excel and CSV
• Collapsible columns
• Grand total for columns and rows
• Frozen (fixed) columns and rows
• Expanding and collapsing rows
• Tree mode
• Custom marks for cells
• Vertical orientation of text in grid headers
• Setting limits on loaded data
• Read-only mode

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.