Hello, assuming this is a very quick one, although I am not finding the appropriate code. I have a report with several pivot tables where in certain instances, will need to exclude an option from the filters within each pivot table.
The attached shows three basic pivot tables where I am trying to set up code that will ensure "NJ" is Not selected. When I use code using the "<>" expression, I receive a compile error. Is there a better way to code for Not selecting a value that will populate all pivot tables?
Thanks!
Sheryl
Bookmarks