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

    expression to exclude customers

    Joanna Seldon



      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