BI Viewer pivot table expansion

[NicoleBruno]

Hi all, 
Is there a way to have the pivot grid in a BI viewer automatically expanded? I've built a custom JE report as a grid but the user has to expand every single column in order to see the JE description for example before exporting in order to get that data on the export. It's manual work where I should be able to set up the pivot to default as expanded or there should be an "expand all" button. 

Appreciate any direction you can provide! 

Thanks! 

-Nicole

[JackLacava · Accepted solution]

Does this option work for you? It's from v7.2, not sure when it became available. Make sure you select the pivot to get it.

[NicoleBruno]

Superb - thank you!!