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?