Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expand in pivot table

In my report I am showing data in Pivot Table, most in collapsable format. Can i perform any action on button click to expand all the collapsed rows in one go.

Is there anyway to achieve this.

Thanks,

1 Solution

Accepted Solutions
Not applicable
Author

Thanks Boris for your reply.

Yes, I can do that but in that case then collapse option doesn't appear on the screen.

Anyways there is another way to achieve this, user accessing the report via web can always right click on the column and say expand / collapse.

View solution in original post

2 Replies
bgerchikov
Partner - Creator III
Partner - Creator III

Hi,

You can keep your pivot table Always Fully Expanded by checking this box in chart properties --> Presentation tab. Otherwise, users should expand/collapse manually.

Hope this helps.

Not applicable
Author

Thanks Boris for your reply.

Yes, I can do that but in that case then collapse option doesn't appear on the screen.

Anyways there is another way to achieve this, user accessing the report via web can always right click on the column and say expand / collapse.