Exclude one Value from a Filter

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

Thanks again for the response. Unfortunately, and as much as I love slicers, they do not work. The 'actual' report I have contains about 30+ pivot tables from a few different sources, reason I am looking to set up a quick way to use VBA and de-select, if possible, the one value from each pivot table filter.

Is there code that is (something like) .Criteria1 = "<>=NJ" ? I tried playing around with that, but it is not taking.

Sheryl

Thank you. Interesting way to make it work, appreciate it. Unfortunately still does not work as I need the "state" option to remain within the filter. So if possible, am trying to find a way to keep "State" in the filter, so that All options are selected, with the exception of (in this case) "NJ." Wondering if doing this a long way and setting up the filter to include all options, except the one I need, would be better. There are about 100+ options in my real report, so hoping to avoid that, but it could work for the one time build, I suppose, using the Criteria1:=Array( "ABC", "XYZ", "123") type option?

Thanks again.
Sheryl