How to Filter Dimension value ?

[#1]

Hi,

How to Filter the Dimension  value based on custom filter containing in a listbox. The list box contains few values of Dimension value.

Lets Say: Client is the dimension

I have Table

Client	Col A	Col B
X	some value	some value
Y	some value	some value
Z	some value	some value
P	some value	some value

and I have list box containing few client to exclude from the main table

Client

Z

P

On selecting the Client list box I shd be able to the main table exluding Z, P

Client	Col A	Col B
X	some value	some value
Y	some value	some value

Any help is much appreciated

[Gysbert_Wassenaar]

In the attached example you can find two options. The table box uses alternates states and two actions assigned to a field trigger. The straight table uses a set analysis expression (that is hidden).