1 of 1 people found this helpful
You can add this calculation
if [Placeholder 1 Selector]='Category'
ELSEIF [Placeholder 1 Selector]='Product Name'
then [Region]!='No region' END
Please mark the answer as CORRECT and HELPFUL if it has helped you.
This seems to have done it. I was trying to over-complicate matters on my own. Quick question: what does the following line in your code mean:
"then [Region]!='No region' END
Hi Eric ,
I have randomly taken one word which can't be in your Region. (It can be anything such as xxx , yyyy which can't be a region )
Condition is that Region should not be equal to (notice this sign ! there , means not equal to ) a Random non region name
---->Hence it will select all the regions
Hope it helps !
Please mark the answer as CORRECT and HELPFUL if it has helped you so that it can help others as well
Ah, that makes sense, thanks. Is there a way to allow null values to be included there as well? For example, if there was South, North, East, West, and null (maybe outside of USA, so data is null).