Hello,
I have filters on my pivot table. As I filter the data further, the number of columns reduce (I presume because they would be empty if they didn't). Is there any way to prevent this? In the Column Labels dropdown I can see all the missing columns with a tick on them but they don't show up on the table.
Bookmarks