I am giving the example using Excel, but I guess the basic idea would be understandable. Currently dhtmlxPivot gives something like the following image -
Can we have something like the following - where the first column contains the group field flattened -
Let e give an example when it is required - if I want a pivot but the left side columns are not grouped, for example, if I need to show Region - District - Facility - > then the columns to show a pivot data of 12 months. I do not want to group by Region or District. Because when I export to Excel it is not usable if the data is exported as the pivot format. Every row need to have all the data.