expression to exclude customers

[joeybird]

Hi

each customer has a Customer ID.

I have a stacked bar chart with a written expression to count the number of orders from each department

e.g Catering, Homeware, Children.

however I want to count the customer ID's that have ordered from Children, and other departments.... on the bar chart I want to exclude the customerIDs that have only ever ordered from Children department

please help

[Chanty4u]

chk it

Excluding values in Set Analysis

[swuehl · Accepted solution]

Maybe like

Count({<CustomerID -= {"=ONLY(Department)='Children' "}>} DISTINCT CustomerID)

Note the minus sign before the equal sign,

[joeybird]

brill thank you x