exclude function for dimension

[manoj217]

Hi all

I have a fields in straight table and i want to exclude some values in dimension dynamically.

fields like

A	B	C	count(A)
apple	red	3	1
ball	green	4	1
cat	yellow	3	1
dog	white	2	1
elephant	ash	5	1
fox	orange	1	1

now if i enter any value in input box it should not visible in the straight table

example :

if i enter apple,ball

it should not appear in the straight table

[jensmunnichs]

You would have to add set analysis similar to the Count(A) expression to any other expression you put in the table. So in this case it would be:

Count({<A-={$(ExcludeA)}, B-={$(ExcludeB)}, C-={$(ExcludeC)}>} DISTINCT A)