8 Replies Latest reply: Jun 27, 2013 7:25 AM by Rene Van Halle RSS

    Mapping sales based on two variables

      Hope someone can assist as I try to link sales based on two different variables (post code and division) to one sales person.

       

      Post CodeAccessoiresShoesEquipmentClothing
      1680LesPaulLesAllan
      1685SarahClydePaulPaul
      1700ClydeSarahAllanLes
      1701PaulLesReneSarah
      1710SarahReneSarahRene

       

      So if a sale is reported on postcode '1680' and 'shoes' the sales should be aligned to Paul. If the combination was '1680' and 'Clothing', then the sales should be aligned to Allan?

       

      Any suggestions on how to write the script?

       

      Thanks in advance.