Need to select only counties in NY

[grecon]

I want to select only the counties in NY state how would I write a formula to do that? My counties are in ADDRESS.COUNTY and the state is ADDRESS.STATE Thanks

 

[fisheromacse]

in your selection criteria, use: ADDRESS.STATE = "NY

 

[grecon]

Thanks, I can't do that since I need to still see all the states but I figured out a way
if {ADDRESS.STATE}= "NY" then {ADDRESS.COUNTY}