case statement for data limiting expression

[Anusha V]

Hi,

India has 2 records one is Consumer and another corporate but whenever we have Consumer it should list only Consumer, But when we dont have Consumer it shoul list rest all categories.

 

 

 

ColumnA

Segment

output in detai Vizualization

Remarks

 

 

India

Consumer

Consumer

 

 

 

India

Corporate

will limit the record

If we limit consumer in filterpanel record has to be appeared

 

 

India

Corporate

will limit the record

If we limit consumer in filterpanel record has to be appeared

 

 

Japan

Corporate

Corporate

If we limit consumer in filterpanel record has to be appeared

 

 

Japan

Corporate

Corporate

If we limit consumer in filterpanel record has to be appeared

 

 

China

Consumer

Consumer

 

 

 

China

Corporate

will limit the record

If we limit consumer in filterpanel record has to be appeared

 

 

 

i ahve written expresion like data lmiting casen when find ("Consumer", uniqueconcatenate([segment]))=1 then[segment]= "Consumer" else[segment] is not working

[Fabian Duerr]

Try with a calculated column if this gives the desired result:

case

when Find('Consumer',UniqueConcatenate([segment]) OVER [ColumnA]) > 0 and [segment] != 'Consumer' then 'hide'

else 'show'

end

Since you want to consider the countries in CloumnA you have to use a OVER function.