3 Replies Latest reply on Jun 17, 2014 7:00 AM by Suhrid Ghosh

    How do I show an attribute for only MAX(date) and not other dates?

    Keshia Rose

      Hello! ^.-

      I have a set of data for participants in a program. Participants can leave the program and return to the program multiple times. Each time they leave the program, the reason for leaving is recorded. I want to know; For the most recent time a participant left the program, MAX([Date Left]), what was the reason that they left?


      Here's some sample data (included in packaged workbook and Excel):

      Raw Data.pngEasy.pngGoal.png

      I can get to see the max date for a person easily but once I add the Reason it includes all the dates not just their most recent one.


      If you could help me figure this out I would greatly appreciate it!