Set analysis

[thewillemzelluf]

Hey,
I have a question about set analysis.
I would like to select the turnover of all customers except 4. I have no idea how I can filter this via set analysis. I thought of Sum ({1 - $ <CustomerID = {1120,1121,1122,1123}>} Total sales) but it does not work: P

does anyone have any idea what I'm doing wrong?

[awhitfield]

Hi Willem,

please see the following for Set Analysis Exclusion:

Excluding values in Set Analysis

Best regaards

Andy

[sasiparupudi1]

Try

Sum ({1<CustomerID -= {1120,1121,1122,1123}>} Total sales)

[Qrishna]

you can try -

if you want to include any current selections:

Sum ({$<CustomerID = {'*'} - {1120,1121,1122,1123}>} Total sales)

or

Sum ({$<CustomerID -= {1120,1121,1122,1123}>} Total sales)

if you want to exclude all current selections:

Sum ({1<CustomerID = {'*'} - {1120,1121,1122,1123}>} Total sales)

or

Sum ({1<CustomerID -= {1120,1121,1122,1123}>} Total sales)

[sagarkharpude]

Sum ({$<CustomerID = {'*'} - {'4'}>} sales)

[thewillemzelluf]

Thankyou all!

All the solutions did work out