12 Replies Latest reply on Nov 9, 2018 10:41 PM by Klas Berg

    Use date from one dataset to get sales from a second dataset

    Klas Berg

      Hi everybody.

       

      I have a question (first one!) that I can't seem to find the answer to.

      How can I get sales per customer based on that particular customers purchasing date from another dataset.

       

      Example:

      Dataset 1 contains information regarding renting equipment.

      Dataset 2 contains sales that we want to see starting at the "rent date".

      IE: Customer NN rents product X in Dataset 1. How much has the customer bought (found in dataset 2) from that particular date in dataset 1.

       

      Attaching superstore workbook but it probably won't help since I don't know where to start..

       

      Best regards,

      Klas Berg