We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

JavaScript Pivot Table

The pivot table is a multi-dimensional data visualization component built on top of relational data sources. Pivot report can be managed dynamically at runtime along with other capabilities like aggregation, filtering, and sorting (field and value based).

Data binding

The pivot table can be bound to data in the form of JavaScript object array collections. It uses the Essential JS 2 data manager explicitly to handle remote data and data processing.

JavaScript pivot table control renders with relational data source in JSON format

JavaScript array collection

An array of JavaScript objects can be bound to the pivot table, allowing it to work smoothly in applications.

Remote data binding (RESTful API) with pivot table in JavaScript

Remote data binding

Binding the pivot table with RESTful services allows data from services to be consumed using the Essential JS 2 data manager explicitly. It supports various data adaptors such as JSON, OData, ODataV4, URL, and Web API for working with a particular data service.

Summary exploration

Pivot table provides built-in drill down and drill up capability to visualize data both in detailed view and abstract view, respectively. By default, pivot table displays data in a summarized format.

JavaScript pivot table with drill up and drill down support

Virtual scrolling

The high-performance pivot grid allows users to load large amounts of raw data, aggregate it, and view it on-demand through horizontal and vertical scrollbar options with ease.

Virtual scrolling support in JavaScript pivot table

Data manipulation

Filtering support in JavaScript pivot table


Filtering allows users to view only specific records in the control using complex filter criteria with the help of member, label, or value filter options, similar to Microsoft Excel.

Sorts in ascending and descending order using JavaScript pivot table


Allows users to order both fields and values (column) either in the ascending or descending order.

Aggregation support in JavaScript pivot table control


Users can perform calculation over a group of values using the aggregation option. By default, values are summed. The other aggregation types include average, minimum, maximum and count.

Pivot field list and grouping bar

The field list and grouping bar are automatically populated with the fields from the assigned report. They later allow end users to drag fields, filter, and sort them, and also create pivot views at run time.

JavaScript pivot table control along with field list and grouping bar

Calculated field

New value field(s) can be added based on a simple mathematical formula to their report either through built-in dialog at run-time or through code behind.

Calculated field (user-defined field) in JavaScript pivot table control

Frozen header

By default, row and column headers are frozen to allow scrolling and comparing cell values with the corresponding row and column headers.

Freezes row and column headers in JavaScript pivot table control

Conditional formatting

Conditional formatting allows users to apply styles to value cells by changing grid cells’ font style, font color, background color, and font size.

Conditional formatting support in JavaScript pivot table control


Resizes columns in JavaScript pivot table control


Resizing allows changing column width on the fly by simply dragging the right corner of the column header. The scroll bar will appear when the pivot table content width exceeds the element width.

Reorders columns in JavaScript pivot table control


Columns can be reordered either through user interaction or programmatically. Simply dragging and dropping a column header into the desired column position will reorder the columns.

Optimized for mobile devices

Touch support for JavaScript pivot table control

Touch support

All pivot table features will work on touch devices with ease. Features such as drill up/down, filtering, sorting, and report manipulation can be done on the fly.

Responsive view of JavaScript pivot table control


Responsive features allow the pivot table layout to be viewed on various devices.

Field list support in JavaScript pivot table control to create reports dynamically at run-time

Adaptable field list UI

It allows the pivot field list to be viewed on various devices.


Exports pivot table data to Excel, PDF, and CSV formats. The exported document can also be customized to add header, footer, and its cell properties like type, style, and position programmatically.

Exports report to Excel, PDF and CSV in JavaScript pivot table control

Globalization and localization

Globalization support in JavaScript pivot table control


Enables users from different locales to use pivot table by formatting the date, currency, and numbering to suit locale preferences. This uses the Essential JS 2 internalization library for handling value formatting.

Right to left (RTL) support in JavaScript pivot table control

Right to left {RTL}

Supports right-to-left rendering, allowing the text direction and layout of the pivot table to be displayed from right to left. This improves user experience and accessibility for RTL language users.

Localization support in JavaScript pivot table control


All the pivot table strings in the user interface can be localized as needed. The pivot table uses Essential JS 2 localization library to localize UI strings.


Transform your applications today by downloading our free evaluation versionDownload Free Trial

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon