2 Replies Latest reply on Aug 1, 2013 12:50 PM by Anya A'hearn

    Finding the last entry per category

    Anya A'hearn

      I am looking for assistance in filtering on the last category that was entered.  In the attached sample, a student can take multiple tests throughout the year to assess what level they are at.  I only want to show the last level of testing that the student achieved (indicated by the filter Proficiency Level = Independent).  (note:  Not all students are tested in each cycle.)

       

      I can do this with a join to a copy of the table filtered on Max of the System Test ID, but I was trying to avoid this route.

      Thank you.