5 Replies Latest reply: May 2, 2018 3:57 AM by willem van der Plas

# Set analysis

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?

• ###### Re: Set analysis

Hi Willem,

please see the following for Set Analysis Exclusion:

Excluding values in Set Analysis

Best regaards

Andy

• ###### Re: Set analysis

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)

• ###### Re: Set analysis

Try

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

• ###### Re: Set analysis

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

• ###### Re: Set analysis

Thankyou all!

All the solutions did work out