Pivot Table JavaScript UI widget for web developers

JavaScript Pivot Table is a UI widget that can be integrated into any business application. With the Pivot toolkit you will be able to create Pivot Tables, user reports, make complex data selections and even build pivot charts. Webix Pivot offers a ready-made solution for web applications developers. At your disposal there will be a detailed documentation, sample codes collection, thoughtful material design and deeply optimized code for the uncompromising performance

pivot-table
1 2 3 4 5

1. Data aggregation

Extract significant information from huge data sets. Organize, summarize and compare complex data with ease.

2. Data export

Export data to various formats: PDF, PNG, Excel and CSV.

3. Flexible UI customization

Customize datatable settings, tune the configuration window and adjust filters.

4. Custom operations

Create your own functions for data aggregation.

5. Localization

Adjust dates, numbers, monetary units and text labels associated with particular countries.

What is Pivot?

Pivot is the way to present summary reports in the form of a table. It is an irreplaceable tool for creating reports from aggregated data. Pivot allows to work with complex structures of data bases and to create simple clear reports. Pivot tools allow to select necessary data sources and correlate them with different parameters. Also Pivot tools can sort out, sum up and analyze any amounts of information. JS Pivot becomes a powerful analytical tool in the hands of an experienced user. Webix offers a ready-made solution, which is Pivot JavaScript widget. It can be integrated in any business application.

Webix JS Pivot Table (Grid) advantages

No back-end is needed

Webix Pivot allows to make all calculations in the browser. Users can create any reports without programming.

Remote data processing option

It is possible to configure Pivot Table in such a way that its data are processed by a custom server-side script.

Highly optimized pure JavaScript

Fast calculations and responsive interface even while working with huge data volumes.

Pivot charts

Extended Pivot options to create summary reports with charts.

Easy back-end and front-end integration

Straightforward integration with various back-ends (PHP, Node.js and .NET) and front-ends (jQuery, AngularJS, Vue.js, React and many third party libraries).

Web accessibility

Complies with Section 508 and WAI-ARIA standards and supports keyboard navigation.

Advanced Pivot features for your JavaScript web apps

features-1

Search for the data with a number of visual tools to get to the needed records with ease.

features-2

Track the dynamics of a certain parameter by sorting it in the ascending or descending order.

features-3

Emphasize significant values by providing color accents.

features-4

Keep an eye on summed values per each row or column in the report.

features-5

Change the structure of your Pivot Table by dragging and dropping tiles in the built-in configuration window.

features-6

Create and apply structures to alter data presentation with a single mouse click.

JavaScript Pivot Table live demo

Pivot Table JavaScript coding samples

Setting/Getting structure

Setting/Getting structure

Ability to set the necessary data and get the desired view of the table

Loading CSV

Loading CSV

Ability to upload a chart in CSV format

Export data from the Pivot

Export data from the Pivot

Ability to upload data in PDF, Excel, CSV formats

Defining chart properties

Defining chart properties

Ability to change chart parameters and values

DateRangePicker filter

DateRangePicker filter

Ability to select the desired date depending on the required data

Sorted Header

Sorted Header

Ability to sort data by title

FAQ

What are complex widgets?

These are full-fledged single page apps with the ready-made back-end and front-end layers, that can be downloaded and built into any solution. A full list of complex widgets can be found here.

What is the maximum table size supported by Pivot?

Pivot has no restrictions on the table size. But keep in mind that creating and rendering very large amounts of data can lead to time lags in the work. Make sure you have enough system resources. For example, a table with 10,000 rows and 30,000 columns will require 1.5 Gb of physical memory. In such cases, it is more reasonable to use pagination.

Is Pivot compatible with the Webix community (opensource) edition?

No, it isn't. All complex widgets require the commercial package Webix Pro.

Can Pivot create Pivot Charts?

Yes, they can. Pivot includes another component for creating Pivot Charts, so you get two products for the price of one.

Where does Pivot perform calculations: on the back-end side or in the browser (front-end)?

By default, all calculations are performed on the client side, in the browser. But we have provided the possibility to transfer calculations to the back-end side using the Web Worker tool.

Is Pivot compatible with Angular or React?

Yes, it is. We provide examples of our widgets integration into any modern frameworks.

Will Pivot work after the trial period expires?

When the trial period expires, all the functionality of the Pivot will be blocked. But you can contact us to extend the trial period up to 6 months.

Can I change the UI and the design for Webix Pivot?

Definitely. Complex widgets are easy to configure, integrate, and customize. To help with that we have created a detailed documentation.

Webix Pivot licensing