5 Cool Features of Our JavaScript Pivot Table

There may be different requirements for the pivot table that you work with. According to your needs, you may want to highlight particular cells in order to improve readability of data. Sometimes your requirements are much higher, and the possibility to make quick reports is the must. In any case, have no fear. Our advanced Pivot grid is able to cope with both of these tasks. Moreover, there are many more handy features. Want to know which ones? Well, it seems like it’s your happy day because in this article we’ll consider five cool features of our JavaScript pivot table that can significantly simplify the way you work with data.

  1. Conditional Formatting of Cells

You can change the appearance of the pivot table by highlighting cells that contain particular values. There’s a possibility to change the color of the cell depending on the specified condition. For example, you can use the predefined functions that can find min and max values in the column and apply custom CSS styles to them. Besides that, you can define your own functions for styling. This feature allows creating custom criteria for cell highlighting.

2. Export to Excel

You can export tables created in an online application to an Excel file. You can be assured that exporting won’t affect the appearance of the document. The exported file will contain all formatting such as the color of cells, for example. dhtmlxPivot allows configuring different aspects of the exporting operation such as the name of the exported Excel file, for example.

3. Filtering

Since your pivot table can contain different types of data, our developers provided you with advanced filtering feature. You can define a particular type of filtering for fields depending on the type of data they contain. As well, you can remove all the applied filters at once. Pivot table contains UI elements that allow users to interact with the application by applying a particular filter.

Depending on the type of data used in the pivot table, you can use one of the following filters:

  • string filter
  • number filter
  • dates filter

Besides that, you can use a Global Filter. It allows applying several filtering rules at once and will be helpful if you work with some complex data.

4. Grouping Data by Dates

In case you work with a big dataset consisting of dates the possibility of configuring date fields can be pretty helpful. It allows you to group displayed data by dates. There’s the possibility to choose the necessary type of grouping. You can click the toggle button in the date field to choose between the following options: Day, Week, Month, Year, Quarter. For example, you can select a particular period of time to be displayed. After that, if you choose the Month option, the pivot will take from the dataset all values related this period and render the month summary on the screen. Such feature can be used for quick report creation.

5. Custom Templates for Headers

The appearance of column and row headers can be changed using custom CSS styles. Using templates, you can define which color and font will be used for a particular header. Thus, you can make a visual emphasis on a particular column or create a design that better fits your web application.

Visit dhtmlxPivot page for more details.