filter dimension

[raadwiptec]

Hi all,

I need to filter a dimension

For ex: Customer Id is the dimension

On the Chart I need to show only Customer Ids with 200 ,250,300,450

rest should not be shown and should be hided ..it is a pivot chart and customer id is on the horizontal line

[raadwiptec]

Can I also put the same concept for if then condition

for ex in the calculated dimension

if (customer id = 300 ,'Low' ,

so for multiple conditions how can we do it

[sathishkumar_go]

for multiple condition, use have to use nested if.

example:

if (customer id = 300 ,'Low' ,

customer id = 200 ,'High' ,Medium)

-Sathish

[raadwiptec]

no this does work it is giving error

[sathishkumar_go]

Sorry. use this

if (customer id = 300 ,'Low' ,

if(customer id = 200 ,'High' ,'Medium'))

[MK_QSL]

You are struggling to get a correct answer since 4 hours which seems to be very easy.

If you provide sample data or sample application, you can have your answer within 10 mins..