Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is it possible in pivot table that if I collapse one of the values of dimension then all the other ones should also collapse in the same dimension if they are expanded.
Regards,
Maybe
Right click on mouse -> Expand/Collapse All
Yes you can , just make sure the "always fully expand" checkbox is uuncheked on the presentation tab
Click on the dimension Right Click > Collapse All