- 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.
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.