6 Replies Latest reply: Jan 13, 2018 5:51 AM by Ruben Marin RSS

    Flag Customer IDs based on count and year

    Karan KN

      The question will be little tricky:

       

      Define a field based on a ID, when we select the current month from Sales_Date (ex: Nov 2017):

      - New IDs of current month = NewITM,

      - Duplicate IDs from historic data define by year

        >1 year OldITM

        >2 year OldITM

        >3 year OldITM


      imglo.PNG