Vizlib Home

Export to excel preserving the drill down


In a vizlib custom report I can easily simulate an excel pivot with collapsible and expandable drill down elements. 

For example if I have this pivot, I can reproduce it in a custom report, where it is possible to expand or collapse 'com1', 'com2', etc.


Now, if I have this pivot on my custom report, I can export it in excel, but i will lose the possibility of expand/collapse elements; i will have either everything expanded, but in different columns, or everything collapsed.

Is there a way to keep the structure of drill down elements, so that they when the report is exported into an excel file, elements can be expandend/collapsed by users on excel?

Thank you

Login to post a comment