Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We have an location field which having all locations but we have to capture only few locations which is to be static all the time.
Logic used :=if(location_new<>'016' and location_new<>'025' and location_new<>'099',location_new)
But the new locations got updated frequently so here am not able to capture only the locations which i required.
Locations need to static every time even if the new locations added = 012,034,045,067.
Thanks..
I made a small sample and I have to correct my statement
define variable vLocNew as
'012','034','045','067'
define calculated dimension
=if (match(Location_new,$(vLocNew))>0, Location_new,null())
tick suppress when value is null
my result
you could achive also by using set Analysis
sum({<Location_new={'$(=vLocNew)'}>}[Total Orders]
or
sum({<Location_new={'012',034',045','067')'}>}[Total Orders]
Thanks..Rudolf it's working.