Hi I have a pivot table with 5 dimensions and 1 expression. I have two questions.
Is there a way to collapse all columns when the clear button is clicked?
Is there a way to expanded the next column when the first column is selected? I want to navigate to the end and pinpoint the exact data I'm looking for without having to manually expand the columns.
Right now I have all the Always Fully Expanded checked.
Thanks in advance
