Despite much googling (of probably the wrong terms) I can't find a way to prevent this happening:
I've got a pivot table with a few fields in rows, a few fields in columns.
I can't find a way of making value filters persist when new fields are added / pivoted. By value filters I mean: Value Filters > Greater Than
Whilst all the filters on rows persist when their fields are moved - the filters on values don't. Is there any way to make this happen or do I just have to re-apply the filter on every pivot?
Bookmarks