7 Replies Latest reply: Jan 28, 2015 4:48 PM by Steve Zagzebski RSS

    Getting result from most recent year of activity

    Steve Zagzebski

      I am looking for help on an expression that would give me the number of members for a customer for the most recent year of activity. (which could be different for each customer)

       

      RAW DATA:

      Customer     Year     Members

      A                    2013     25

      A                    2014     50

      B                    2012     75

      B                    2013     100

      C                    2010     100

      C                    2012     150

       

      RESULTS:

      Customer      Members from most recent year of activity

      A                    50

      B                    100

      C                    150

       

      Thanks in advance for any help,

      Steve