1 Reply Latest reply on Aug 11, 2013 7:06 AM by Yves Goldberg

    how to calculate/get the number of orders containing at least one specific product? (when it is possible to have multiple products ordered per order)

    Yves Goldberg

      I am trying to count the  number of orders having a certain caracteristic.

       

       

      order 1

      -----------

      prod1

       

      order 2

      ------------

      prod1

      prod2

       

      order 3

      ----------

      prod3

       

      So I need the total number of orders containing prod1 or prod3. the answer from the above exemple is 3

       

      TIA