3 Replies Latest reply: Mar 29, 2016 6:36 AM by Joanna Seldon RSS

    expression to exclude customers

    Joanna Seldon

      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