Pivot Table STOP Mimic

[bemcbride]

Ok, so I have a Pivot Table; the row labels are Year > Period > Journal ID. I have 2 years 2016 and 2017 when I try to expand say period 2 in 2017 it also expands period 2 in 2016. I don't know why this is happening I haven't seen it done before but it's driving me crazy and I need it to stop doing that.

Any advise or help would be great, besides creating another pivot table just for 2017 (too clunky)

Thank you!

 

[CyrusTheVirus]

To my knowledge you can't do what you're trying to do. Though, you could collapse 2016 altogether, then expand the different regions in 2017. Hope this helps.