Multiple value for a condition

Hi All

I am trying to achieve a result for one filter that when i select some value in one filter , in the other filter value based on the condition defined should display those values only .

For eg in one filer if i select A my values related to the A should display .

Suppose there are two values i want to display when i select  A from ffirst filter in the second filter it should display only those values which are meeting the condition

so i have tried written the calculated field for the conditrion like this

case List

when  Active then ''1

when Active then '2'

the problem here is i have two values for Active . When i am writing formiula , calculation is valid but not giving the desired result

Can anybody check on this

Regards

Larsen