I have created a parameter to include and exclude values. I have created one on the STATE.
When I select IOWA, it is getting excluded on the view below. But, at the same time I would like to exclude the other regions and keep the CENTRAL region excluding IOWA state.
data would show as follows
I have a parameter called Filter1 which has a list of states. If I type IOWA into it I want to see
filter statement used
IF [State] != [Filter1] THEN "Show"
what I'd like to do is enter a state eg IOWA and get a result that does this
I've been racking my brains all day on this!