Calculated Dimensions

[#1]

Hi All,

Can some on please tell me how can i add calulated dimension matching mltiple criteria?

For example show all cities whr cd =1, 2,3

I tried this but it will not work because it will concatenate all the matching values      CONCAT(DISTINCT {<cd={1,2,3}>} City,',')

[#2]

Hi Sunny,

Try this .if(Match(cd,1,2,3), City)

Thank you

Vardhan

[preminqlik]

try this ------In dimension :

if(Cd=1 or Cd=2 or Cd=3 ,City)

[senpradip007]

try this:

if( cd < 4, City)

[#5]

Hi Pradip/Prem,

Sorry i forget to add that numbers will not be in order and they are not fix . It can also be text 
Thanks

[rsdhavle]

If

( Match(Cd, '1', '2', '3'), DISTINCT  City)

Try this

[#7]

HI

PFA...Hope this will helps you

Regards

Nirmal

[#8]

can you attach some sample

[#9]

Hi All

Please find the sample file attached.

What i am trying to do is as soon as i click on city Delhi in next chart it should show all sp who's id matches with city's id. For example for Delhi id is 1 ,2 , 4 so I want all sp and count with id 1,2,4 in second chart

[tresesco]

Not sure if understood right. May be you just need to take ID/sp as dimension, like in attached sample. PFA