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

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

License type
License Terms
Package
Projects
Developers
Support
Support tickets
Response time
INDIVIDUAL LICENSE
Webix Pro + Pivot
1
1 developer
Basic
  • Basic
  • Standard (299$)
  • Priority (599$)
10
Up to 72 hours
PRODUCT PACK
Webix Pro + 3 complex Widgets
1
2 developers
Standard
  • Standard
  • Priority (599$)
30
Up to 48 hours
COMPANY PACK
Webix Pro + All complex Widgets
1
Unlimited developers
Standard
  • Standard
  • Priority (599$)
30
Up to 48 hours
DEVTEAM PACK
Webix Pro + All complex Widgets
Unlimited projects
5 developers
Standard
  • Standard
  • Priority (599$)
30
Up to 48 hours
UNLIM PACK
Webix Pro + All complex Widgets
Unlimited projects
Unlimited developers
Priority
Unlimited
Up to 24 hours