{"id":4227,"date":"2017-09-05T09:00:05","date_gmt":"2017-09-05T05:00:05","guid":{"rendered":"https:\/\/dhtmlx.com\/blog\/?p=4227"},"modified":"2025-03-11T13:07:34","modified_gmt":"2025-03-11T10:07:34","slug":"dhtmlxpivot-updated-version-1-1","status":"publish","type":"post","link":"https:\/\/dhtmlx.com\/blog\/dhtmlxpivot-updated-version-1-1\/","title":{"rendered":"dhtmlxPivot Updated to Version 1.1"},"content":{"rendered":"

A new version of dhtmlxPivot<\/a> was not long in coming. Today you’re welcome to try dhtmlxPivot 1.1 with the ability to sort data and headers of rows and columns. Besides, there are plenty of other helpful updates, so continue reading to learn what’s new.<\/p>\n

Or… you can throw everything away and download the new version right now<\/a>.<\/p>\n

Sorting<\/strong><\/h5>\n

Starting from the version 1.1, you can sort rows in the grid part of your pivot table. For this you just need to click on headers and you’ll see ascending\/descending sorting icons.<\/p>\n

\"sorting-dhtmlxPivot\"<\/p>\n

Pre-defined sorting of rows and columns<\/strong><\/h5>\n

With dhtmlxPivot 1.1 you can also define a sorting order of rows and columns before the data aggregation. By default, the headers are sorted in ascending order. Unlike data sorting, it can’t be changed from UI but from API. <\/p>\n

Custom templates for grid headers<\/strong><\/h5>\n

Version 1.1 introduces a way to customize the look of group headers in the pivot. Now you can define your own templates for column and row headers. Any HTML is allowed inside of templates, so you can convert a static text in header into a clickable link, or replace a non-meaningful ID with a real entity name.<\/p>\n

\"pivot<\/p>\n

Also, while previous version has the fixed width for header columns, the new one provides the ability to size the header columns to their content (width of column is automatically adjusted to the width of content). Read docs for more details.<\/a><\/p>\n

Filter data from API<\/strong><\/h5>\n

New version of dhtmlxPivot brings you the ability to filter the data before aggregation, it can be used to narrow your data query. Check sample<\/a> and find mode details in the docs<\/a>.<\/p>\n

Note that filtering is applied before data aggregation; adding or removing the filter will cause the Pivot repaint. UI for filtering is under development now and most likely will be included in the next dhtmlxPivot update.<\/p>\n

Segment data in week mode<\/strong> <\/h5>\n

Due to your requests, we’ve added Week type of date grouping<\/a>. Now there are 5 types of operations that allow grouping data by dates: day, week, month, year and quarter. <\/p>\n

What is more, there is a new method that will allow you to create your own operation for dates aggregation.<\/p>\n

\"week<\/p>\n

Related material:<\/strong><\/h5>\n