BI Viewer pivot table expansion

NicoleBruno
Contributor III

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

1 ACCEPTED SOLUTION

JackLacava
Honored Contributor

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.

JackLacava_0-1692085046493.png

 

View solution in original post

2 REPLIES 2

JackLacava
Honored Contributor

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.

JackLacava_0-1692085046493.png

 

Superb - thank you!!