This content has been marked as final. Show 3 replies
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