how to show this?

[alexpanjhc]

Hello

I have  a client ID that i already selected and i also want to select a group of ID that is in category  X

Client ID	Category
A	Y
B	X
C	X
D	Z

let's say i already have the client A selected so the table will show only first line, but now i also select category X in a drop down list

how can I show A, B, C in the table?

any help will be greatly appreciated.

[marcus_sommer]

It's not possible. There is no association between the data of Client = A AND Category = X.

[Mark_Little]

Like Marcus, Say you can do exactly what you ask because of the associative engine. You can get set analysis to ignore certain selections on Dimensions.

COUNT({<"Client ID">}Category)

But the above example when you select Category X the Client ID would be unselected as no association

[alexpanjhc]

i was thinking using P() but was not sure how

[MarcoWedel]

using a set expression and an alternate state might be a solution :