Expand in Pivot Table

[Anonymous]

Hello,

I have a Pivot Table and I want ALL the columns that pivot to be shown even though the data is collapsed.

Is there any option in the Pivot Table properties?

Thank you very much!

[#2]

See attached. Is this what you want?

[Anonymous]

Not exactly, If it is all expanded, so the expansion icons won't work. My need is to have all the columns expanded but if I collapse any dimension, the column keep showing.

I don't know if I am clear with the information.