Dynamic logic

[nareshthavidishetty]

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..

[Anonymous]

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]

[nareshthavidishetty]

Thanks..Rudolf it's working.