1 Reply Latest reply: Sep 10, 2014 7:58 AM by Massimo Grossi RSS

    Recommended List Analysis

    Dermot mcgoldrick

      Lets say I have a list of recommended items we want a customer to buy, ie the ideal stock holding.  Then I have a list of what has been sold.  I want to map one against the other.

       

      I can easily show a straight table with the list of parts that have been purchased, but it wont show those that are not, I think I need to join the tables?

       

      Sample sales data :

       

      Sales
      CustomerDateItemDescQty
      Mularkies01/02/201410.12.45Flag15
      Stevens15/03/201410.12.55Pole30
      Road Rash Co02/04/201410.12.632Rope10
      Stevens05/05/201410.12.654Grass Seed52
      Road Rash Co15/03/201410.12.45Flag5
      Mularkies02/04/201410.12.55Pole10
      Road Rash Co15/03/201410.12.200Deck Chair25
      Jones Co01/02/201410.12.45Flag14

       

       

      Recommended List :

       

      Recommended
        Parts
      ItemDescRec Qty
      10.12.45Flag5
      10.12.55Pole15
      10.12.632Rope15
      10.12.654Grass Seed30
      10.12.200Deck Chair5
      10.12.5555Parasol20
      10.12.1234Table2

       

      What I'm seeing now :

       

      Recommended
        Parts Results
      ItemDescRec QtyPurchasedPassed?
      10.12.45Flag534Y
      10.12.55Pole1540Y
      10.12.654Grass Seed3052Y
      10.12.200Deck Chair525Y

      ie I'm missing the items what the customer hasn't purchased!

       

      What I'd Like to see :

       

      Recommended
        Parts Results
      ItemDescRec QtyPurchasedPassed?
      10.12.45Flag534Y
      10.12.55Pole1540Y
      10.12.632Rope1510N
      10.12.654Grass Seed3052Y
      10.12.200Deck Chair525Y
      10.12.5555Parasol200N
      10.12.1234Table20N