7 Replies Latest reply on Apr 4, 2017 12:19 PM by Guy Adams

    Sum All Products If Includes Specific Product

    Guy Adams

      I'm sure this is a very simple solution, but I just cannot figure it out.


      I want to sum the total Increment ID Product Sales, if the Increment ID includes Product A or Product B in the Name (Catalog Product Flat 1).



      Product SalesIncrement IdName (Catalog Product Flat 1)
      $12.31100008B1SProduct C
      $4.70100008B1SProduct C
      $2.33100008B1SProduct A



      I'm using 10.1.5