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.
Fast calculations and responsive interface even while working with huge data volumes.
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).
Complies with Section 508 and WAI-ARIA standards and supports keyboard navigation.
Search for the data with a number of visual tools to get to the needed records with ease.
Track the dynamics of a certain parameter by sorting it in the ascending or descending order.
Emphasize significant values by providing color accents.
Keep an eye on summed values per each row or column in the report.
Change the structure of your Pivot Table by dragging and dropping tiles in the built-in configuration window.
Create and apply structures to alter data presentation with a single mouse click.
Ability to set the necessary data and get the desired view of the table
Ability to upload a chart in CSV format
Ability to upload data in PDF, Excel, CSV formats
Ability to change chart parameters and values
Ability to select the desired date depending on the required data
Ability to sort data by title
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.
No, it isn't. All complex widgets require the commercial package Webix Pro.
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.
Yes, it is. We provide examples of our widgets integration into any modern frameworks.
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.
You can enhance Pivot performance by using a web worker. It will allow processing data operations in the background without blocking Pivot UI in the browser.
Explore supplied code samples to get the idea of how Pivot Table JS widget can be used in web applications.