Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
See attached. Is this what you want?
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.