1 of 1 people found this helpful
I'll bet you have no dimensions on rows or columns.
Create a bogus calc. Call it [A].
This is what it will contain:
Now drag that to ROWS. You'll see the "A" show up as if it's a label. Right click on that [A] pill, and uncheck "show header". The "A" will go away, but now you have a dimension on the sheet. Do that on both pie charts. Your sheet swapping will now function the way you want it.