Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a dimension called "Shipping country" which is being set as Master item.
Currently that dimension include all countries available. However I would like to exclude a certain country from the list
=[Shipping country_id]
Either if I can set a certain filter where I include it or could I just add some logic to the code above for the dimension. The country I would like to exclude is country code DE
Hey!
You can use Wildmatch or match on master dimension, then on your chart "Supress zero values"
if(not(WildMatch(Country,'DE*')), Country)
Thank you. It works when I use the dimension as a filter. However I would like to add it to a summary,
More so it looks like attached: