asked on March 31, 2017
Please refer to attached screenshot. I have large data sets and Normally I prefer to play with report in microsoft excel. For this purpose I am using classic view, because it uses separate column for each dimension, but there is issue, Group values for each hierarchy is not repeated till end of group which makes it difficult to filter records in ms excel.
Screenshot explains everything.
Best regards
⋅ March 31, 2017
Hello Saad,
Thank you for your question. To improve pivot grid cells the way you need we recommend to use customizeCell API method. We have prepared the example on JSFiddle showing classic view with repeating row values. Please note, export to Excel with customizeCell method will be available in the next minor release 2.313 (ETA Apr 10). Does it work for you?
Regards,
Tanya
⋅ April 1, 2017
Perfect! 🙂
Waiting for export functionality.
⋅ April 10, 2017
Hello Saad,
I am glad to inform you that the export of customized cells is ready in the 2.313 version which is available for download now.
You are welcome to update the component.
Kind regards,
Dmytro
