Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Maybe like
Count({<CustomerID -= {"=ONLY(Department)='Children' "}>} DISTINCT CustomerID)
Note the minus sign before the equal sign,
Maybe like
Count({<CustomerID -= {"=ONLY(Department)='Children' "}>} DISTINCT CustomerID)
Note the minus sign before the equal sign,
brill thank you x