Pivot Table options

[jjking58]

Hi All,

Can someone tell me how to enable the  Expand all,Collapse all,Collapse Dimension Rows, and Collapse Dimension columns.

Mine are grayed out.

Thanks in advance

[Anil_Babu_Samineni]

Check in presentation tab or create create 2 buttons for controlling those 2 actions

[Kushal_Chawda]

Check the option highlighted in presentation tab

[rubenmarin]

Hi Jim, I only find those when I right-click on table title, right-clicking on the table rows always shows me at least a few options enabled.

[jjking58]

Thanks Ruben that worked. Also thanks to Kushal and Anil for your assistance