"not" function

[#1]

Hi all,

I'm trying to solve a question and I don't even know if it is possible to solve.

Example:

Table with Person and attribute

Person1 attribute A, B

Person2 attribute A,B,C

Person3 attribute B,C

Person4 attribute A,C

Person5 attribute A

I would like to have a sort of "not" function: when I decide "I want to remove alle the people with A attribute", remove all the people with A even if they have also another attribute.

I did a try with the And/Not function but when I use the not (colouring in red the A attribute) function only the person 5 is removed from the selection.

Any idea?

Thanks in advance

Diego

[Anonymous]

please clarify your table

Person, Attribute A , Atttribute B

Person 1 , value , value

.

.

How does it look like , the first table is not structured clearly