If i understand your requirement correctly, could you make a calculated field to filter?
[state] = "florida" or [state] = "new york" or [state] = "texas
"Then filter on true.
or if you need the markets you could do
if [state] = "florida" or [state] = "new york" or [state] = "texas" then [market] end
Hope this helps!
Thank you Matthew
That gets me part of the way there, but then I lose the detailed data. For example, I'm seeing
EAST > MAJOR MARKET > Florida
(but I lose the other states in the viz - Massachusettes and New York)
My actual formula is more like:
if CONTAINS([url],'xyz') AND CONTAINS([url],'zzz') then [rowid] end
I got some help from a colleague who suggested using sets with a condition such as:
MAX( IF CONTAINS([url],'XYZ')
Dragging this set into the filter did the trick.