Help. I have a pivot table on top of a data set that is constantly changing. I have set a pivot filter to a specific value but as the data gets refreshed, new values appear checked off on the pivot filter without me doing it. Additionally, if the data set does not contain the value I selected in the filter, i want it to show nothing, however, it randomly picks from the list. I don't know what to do and this is causing all kinds of issues.
Please help