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.
Easily search for the necessary data with the help of visual tools
Track changes in parameters by sorting in ascending and descending order
Highlight important information in different colors, highlight the maximum and minimum values in rows and columns
Summarize the indicators in the rows and columns of the reports
Change the order of rows and columns of the Pivot Table by dragging elements of the configuration window, adding custom configurations
Create and apply structures to change the representation of data in one click
The ability to conveniently configure the report
The ability to export data to PDF, Excel, CSV, PNG
Ability to create and apply structures to change data presentation in one click
Ability to display an external filter
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.