1 Reply Latest reply on Nov 22, 2018 8:41 AM by Shinichiro Murakami

    Get maximum date before another date in a column field

    Giorgio Meucci

      Hi All,

      I have this situation:

       

      Customer_IDItem
      Sale Month
      11111A201801
      11111B201801
      11111A201802
      11111A201804
      11111B201804
      22222A201802
      33333A201802
      33333A201803

       

      I need to create a static field that for each set (Customer_ID,Item,Sale Month) returns the previous month when the customer bought the same item BEFORE that month

       

      Customer_IDItem
      Sale MonthLast Month
      11111A201801
      11111B201801
      11111A201802201801
      11111A201804201802
      11111B201804201801
      22222A201802
      33333A201802
      33333A201803201803

       

      The hardest part is that the field should not be depending of the fields and filters actually appearing in the dashboard (since it is just a starting point that I need for other calculations and aggregations), so I can't just use a LOOKUP function.

       

       

      Is it possible?

       

      Thanks for your help,

      Giorgio