Pivot table flattened columns

Pivot
#1

I am giving the example using Excel, but I guess the basic idea would be understandable. Currently dhtmlxPivot gives something like the following image -

pivot_group_column
pivot_group_column3200×1800 495 KB

Can we have something like the following - where the first column contains the group field flattened -

pivot_flat_columns
pivot_flat_columns3200×1800 511 KB

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.
Any idea?

#2

Anyone from DHTMLX reading? Any idea?

#3

I apologize for the delay with the reply.
Unfortunately it is not available to modify the export service to suite your needs.

#4

Sorry I did not ask for ‘flattened export’. I asked whether the display of the pivot left side columns can be flattened in the view (as of I know you used Treeview in the left side column display), can the columns be displayed as gridview.

#5

I apologize. I see. Unfortunately such view customization is not available.

#6

I also encountered similar needs. How do you solve it in the end?