asked on April 23, 2018
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)
⋅ 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
