Is it possible to have multiple groups on datatable?
Not quite sure what do you mean
TreeTable can have unlimited levels of data nesting.
http://docs.webix.com/samples/15_datatable/30_treetable/12_export.html
Actually what I need is someting like TreeTable but I need to sort the groups as well.
for example:
country->city->year->population
i need a drill down report on this data (group on country, city)
but when I sort population column It only sorts data inside groups. The groups are also needed to be sorted.
I can’t achieve this sorting behavior with TreeTable.
If I can have this feature on DataTable then I can unroup data before sorting and re group it after sort.
Sorting in TreeTable sorts all levels (it sorts data for each level separately), so if you have population value in country/city rows, then they will be sorted as well. You can define your own sorting rules if necessary.
http://docs.webix.com/datatable__sorting.html#customsortingfunctions
Also, DataTable support multi-level grouping, just call group command few times. Stil, I think that using TreeTable is a more straight approach.