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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Trusted by the world’s leading companies

Syncfusion Trusted Companies

Overview

The HTML5/JavaScript Pivot Table is a powerful control used to organize and summarize business data and display the result in a cross-table format. It includes major functionalities such as data binding, drilling up and down, Excel-like filtering and sorting, editing, Excel and PDF exporting, several built-in aggregations, pivot table field list, and calculated fields. A high volume of pivot data can be loaded without any performance degradation using row and column virtualization.


High performance

Allows users to load large amounts of raw data into the pivot engine, aggregate it, and view it on-demand through virtual scrolling options with ease.


Data binding

The JavaScript pivot table accepts JSON array for data binding. It uses the data manager explicitly to handle remote data and data processing.

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

JSON format - array of objects

You can bind an array of objects to the control to work smoothly in applications.

Remote data binding, remote web service and RESTful API, in JavaScript pivot table control

Remote data binding

Binding the JavaScript pivot table with RESTful services allows data from any sources, including Excel and CSV files, SQL databases like Microsoft SQL, MySQL, and PostgreSQL, and collections like IEnumerable, IList, and array lists through services, which are consumed using the data manager explicitly. It supports various data adaptors such as JSON, OData, ODataV4, URL, and Web API for working with particular data services.


Chart integration

HTML 5 JavaScript charts can be easily integrated with pivot data rendered independently, including functionality for plotting more than 15 chart types. The end user experience is greatly enhanced by including a set of user interaction features such as zooming, panning, crosshair, trackball, events, selection, and tooltip. Highly interactive field list options are available for generating reports on top of the relational data dynamically.

JavaScript pivot table and chart integration


Optimized for mobile devices

Touch support for JavaScript pivot table control

Touch support

All 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

Responsiveness

Responsive support allows the control layout to view on various devices.

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

Adaptable field list UI

Allows the pivot table field list to view on various devices in a presentable manner.


JavaScript pivot table control along with field list and grouping bar

Pivot table field list and group fields

The pivot table field list and group fields option are automatically populated with fields from the bound data source. They allow end-users to drag, filter, and sort fields, as well as create pivot report at runtime.


Drill down/Drill up

Provides built-in drill down (expand) and drill up (collapse) capability to visualize data both in a detailed view and abstract view, respectively. By default, the data are displayed in a grouped manner.

JavaScript pivot table with drill up and drill down support


JavaScript pivot table with defer layout update support

Defer layout update

Users can refresh the control on demand instead of during every UI interaction in Pivot Table.


Editing and updating

Users can create, read, update, and delete operations for raw data at runtime and update their changes to the underlying data source, thereby reflecting the information in all corresponding cells. The control supports various edit modes such as inline, dialog, batch edit, and column edit though an interactive UI.

JavaScript pivot table with editing and updating support


Filtering

Built-in normal and Excel-like filters with advanced filtering options to easily filter and view data as required. It is also possible to filter programmatically.

JavaScript Pivot Table normal filter

Header filtering

Displays only selective values for a field. This can be achieved either through UI or code-behind.

JavaScript pivot table label filtering

Label filtering

Excel-like filtering option across column and row headers either based on label text, date, or number.

JavaScript pivot table value filtering

Value filtering

Excel-like filtering option across column and row headers based on grand-total value.


Sorting

Sorting supports to order rows and columns based on either labels or values.

Normal Sorts in ascending and descending order using JavaScript pivot table

Header sorting

Orders the column and row header text either in ascending or descending order.

Column sorts in ascending and descending order using JavaScript pivot table

Column sorting

Column sorting, also known as value sorting, orders the column value either in ascending or descending order. It is performed by clicking the desired column header.


Aggregation support in JavaScript pivot table control

Aggregation

Users can perform calculations on a group of values using the aggregation option. By default, values are added together. The other aggregation types are: average, minimum, maximum, count, distinct count, product, index, population stdev, sample stdev, population var, sample var, running totals, difference from, % of difference from, and % of grand total.


Calculated field

The calculated field, otherwise known as unbound field generates unique field with our own calculated value by executing a simple user-defined formula.

Calculated field, user-defined field in JavaScript pivot table control


JavaScript pivot table with drill through

Drill through

The drill-through feature easily obtains a list of raw items for a particular value cell or summary cell.


Totals

Subtotals and grand totals are calculated automatically by the pivot engine inside the control and displayed in the pivot table. This helps users make decisions based on the totals. Also, users can show or hide subtotals and grand totals for rows and columns.

Totals in JavaScript pivot table control


Conditional formatting support in JavaScript pivot table control

Conditional formatting

Allows users to define conditions that, when met, format font style, text color, background color, and font size for values and summary cells.


Number formatting and date formatting

Number formatting and date formatting help to transform the appearance of the actual cell value.

Number formatting and date formatting in JavaScript pivot table control


JavaScript pivot table grouping date and number

Grouping date and number

The Pivot Table control automatically groups dates and numbers, so the date type can be formatted and displayed based on year, quarter, month, day, and more. The number type can be grouped by range, such as 1-5 or 6-10.


Frozen header

You can freeze row and column headers to scroll and compare cell values with the corresponding row and column headers.

Freezes row and column headers in JavaScript pivot table control


Columns and rows

Resizes columns in JavaScript pivot table control

Resize

Resizing allows changing column width at runtime by simply dragging the right-most boundary of the column header. The scroll bar will appear when the content width exceeds the control width.

Reorders columns in JavaScript pivot table control

Reorder

You can reorder the columns either on user interaction or programmatically. Simply dragging and dropping a column header into the desired column position will reorder the columns.

Hyperlink in JavaScript pivot table control

Users can retrieve information about a particular cell on hyperlink cell click. It later allows them to perform custom operations programmatically.

Cell selection in JavaScript pivot table control

Cell selection

Select a range of cells.

Tooltip in JavaScript pivot table control

Tooltip

A tooltip provides basic information about a cell while hovering over it with the pointer.

Cell template support in JavaScript pivot table control

Cell template

With cell templates, users can add features like images, checkboxes, and text nodes to any cells with ease.


Toolbar option in JavaScript pivot table control

Toolbar

The Toolbar feature provides a built-in interface for pivot tables to select frequently used features interactively for easy access. These features include New Report, Save Report, Save As Report, Rename Report, Delete Report, Report List, Show Grid, Show Chart, Show or Hide Totals, Export Reports, and more.


Exporting

Exports JavaScript pivot table data to Excel, PDF, and CSV formats. You can also customize the exported document by adding the header, footer, and cell properties like type, style, and position programmatically.

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


Custom style and theme

Built-in theme support in JavaScript pivot table control

Built-in themes

Ships with a set of 4 stunning, built-in themes namely material, fabric, bootstrap and high contrast.

Custom CSS for JavaScript pivot table control

Custom styling

You can customize the appearance of the control to any extent programmatically.


Globalization and localization

Globalization support in JavaScript pivot table control

Globalization

Enables users from different locales to use the control by formatting the date, currency, and numbering to suit locale preferences. This uses an internalization (i18n) library for handling value formatting.

Right to left, RTL support in JavaScript pivot table control

Right to left (RTL)

Supports right-to-left rendering and allows the text direction and layout of the control to display from right to left.

Localization support in JavaScript pivot table control

Localization

You can localize all the control strings in the user interface as needed and use the localization (l10n) library to localize UI strings.


Developer-friendly API

For a great developer experience, flexible built-in APIs are available to define and customize the JavaScript Pivot Table control. Developers can optimize the data bound to the control and customize the user interface (UI) completely using code with ease.


JavaScript pivot table supports cross-browsers

Cross-browser compatibility

It is necessary for the JavaScript pivot table to work on all major browsers across Windows, macOS, Linux, Android, and iOS. Our control is written in pure JavaScript and does not require any plugin on any modern web browsers. It provides a seamless working experience for all Chrome, Firefox, Internet Explorer, Safari, and Opera browsers.


Other supported frameworks

As a pure JavaScript component, our pivot table integrates easily with Angular, React, Vue and Blazor frameworks.


60+ JAVASCRIPT UI CONTROLS

Read independent,
authenticated reviews
on G2 Crowd

Download Now Pricing

What do our customers say about us?

Double quotes

We're using the file formats and Windows/JavaScript list controls a lot. They're fast, easy to use, and the documentation is good and contains examples. Tickets with questions or suggestions were answered within a day, so we're happy to use the Syncfusion libraries.
Daniel Persidok

Daniel Persidok

wpd onshore GmbH & Co. KG

Double quotes

Using Syncfusion Angular and JavaScript controls makes front-end web development a piece of cake. Each component has many properties that can be configured as per your desire, methods that can be used to interact with the element, and a lot of events that trigger at different stages, which makes modifying your components according to the state of the application an easy task. Also, their support is amazing! They always offer a sample working project, which makes it very simple to solve your question about your code.
Carlos Rodriguez Garcia

Carlos Rodriguez Garcia

Vistatec

Transform your applications today by downloading our free evaluation version Download Free Trial

Awards

Greatness—it’s one thing to say you have it, but it means more when others recognize it. Syncfusion is proud to hold the following industry awards.

Syncfusion Awards
Scroll up icon

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