Forum Discussion
Matrix Visual Expand/Collapse Export to Excel
Hello All, We have deveral matrix visuals where we have Row headers with expand/collapse option. When we export to excel its not exporting with expand collapse option. Is there any visual which w...
There isn't a visual that can be exported that will build a pivot table in excel which is what gives it the expand/collapse option.
You could export summarized data which would give you the fields in a table in Excel that you could build a pivot table on to replicate the functionality.
Or you could look into Analyze in Excel which hooks directly into the tabular model and lets you build pivot tables using the model data.