1 2 Previous Next 27 Replies Latest reply on Oct 6, 2015 3:29 PM by Peter Gilks

    create field which is days since min date, by customer

    Peter Gilks

      Hi,

       

      I have a problem I'm currently struggling with and hope somebody can help

       

      Imagine you are a store and you have multiple customers who start shopping with you, but they don't all start on the same date. And then you want to create a chart which shows spending since day 1, across all customers baselined back their individual start dates. BUT there is no separate data table for customer start date. What would the calculation look like?

       

       

      In my head it would have something to do with creating a min date per customer but I just can't figure it out. Attached is an image of what I'm trying to achieve.

       

      No workbook to upload, but Superstores Sales will work for demos if anyone has an answer.

       

      Thank you!

       

      Peter

       

      example mindate.png

        1 2 Previous Next