4 Replies Latest reply: May 1, 2013 9:26 AM by Darren Johnson RSS

    Aggregation

    Darren Johnson

      Hello,

       

      I'm trying to get a count of how many product variants are out of stock on a given week.

      However, I only want to include variants that belong to a product that DOES have stock (in other variants) in the same week...

      An example table would be..

      tbl.JPG

      I would expect the results to be..

       

      result.JPG

      Hope this makes sense. Any advice would be much appreciated!

       

      Thanks

       

      Darren