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

[Frank_Hartmann]

Use this as expression:

count({1-$}A)

Now create a listbox and select the values which you want to exclude from straight table

[manoj217]

thanks for your reply

my requirement is different..

user will enter some values in input box now i dont want to show those values in straight table.

then automatically count will be adjusted right

[manoj217]

i want to write exclude condition to the dimension values in a straight table and those values also change in dynamically

user will give input those values through input box

input values shouldn't appear in the straight table

[jensmunnichs]

Is this what you're looking for?

[manoj217]

i have used =if( not Match (A ,'apple'), A) this function but it is not satisfying my requirement

[manoj217]

user want to remove some values

if he removes a value in field A  then entire horizontal values need to remove in straight table

[jensmunnichs]

Does my file not do that? When you type something in the input box for any of the dimensions it removes that entire row from the straight table on the right. I saved it with the input box already filled in, if you remove the input from the input box you'll see the rows re-appear in the straight table.

Or did you want them to be gone permanently?

[manoj217]

no for temporarily only

i want to find the count of values in a field but sometimes user wants the count of values without his selection

and he wants to hide all the data in the straight table

[manoj217]

count({1-$}A)

this expression is working as expected but initially i want to show all data but it is showing count =0