"<>" Set Analysis

[#1]

Hi,

is there an option like "<>" (not like) in set analysis?
So far I always uses 1-$

Thanks

Aloah

[Miguel_Angel_Baeyens]

Hello,

I would use {<Field -= "expression">} to say that. Hope that helps.

[johnw]

To give an example, let's say you want to see the sum of the sales of all customers but Bob:

sum({<Customer-={Bob}>} Sales)