Ungroup rows from the hierarchy for export

In relation to another question. https://www.flexmonster.com/question/exported-data-missing-header-data-from-the-gid/
How can I ungroup the rows from the hierarchy, so the exported Excel file can be used in a pivot table? In the product (RANet) we currently use we can do this. (See the attached screenshots)
 

1 answer

Public
Dmytro Zvazhii Flexmonster April 24, 2018

Hello Matt,
Thank you for your question. Our component does not support the suggested type of data view. However, please have a look at the following workaround: http://jsfiddle.net/flexmonster/yvmjbp7v/. It seems that the only thing which is different between the view from jsFiddle and the view from the screenshot is the order of City and Country fields. Still, you can export it to the Excel and change the order of the columns in the Excel doc. 
Please let us know if the suggested approach makes sense for you.
Regards,
Dmytro

Please login or Register to Submit Answer