I have a pivot table, simple, in Col A, Year; Col B, Month; Col C, Revenue.
I have a slicer for year, and when I change the year through the slicer, the months automatically collapse, so all that remains is the year in Col A, and total revenue for the year in Col C.
If I double click on the year, the months reappear, but when I change the slicer, the months disappear again. Is there a way to turn off this automatic collapse?
Thank you in advance!
I have a slicer for year, and when I change the year through the slicer, the months automatically collapse, so all that remains is the year in Col A, and total revenue for the year in Col C.
If I double click on the year, the months reappear, but when I change the slicer, the months disappear again. Is there a way to turn off this automatic collapse?
Thank you in advance!