5 Replies Latest reply on Jun 8, 2018 4:53 AM by Franz Duge

    How can I assign a Marketing-Order-Source to a customer?

    Franz Duge

      Hello,

       

      I have order-date (sample-data in the workbook) with the following dimensions/measurements:

      • Orderdate
      • Customer-ID
      • Ordersource (What was the last click before order?)

       

      I want to assign the ordersource from the first order of the customer (MIN (orderdate)) to a calculated field "Customer-source". Do you have any solution for this problem?

       

      Kind regards

      Franz