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



      Customer      Members from most recent year of activity

      A                    50

      B                    100

      C                    150


      Thanks in advance for any help,