3 Replies Latest reply on Mar 8, 2018 8:36 AM by Ivan Young

    View historic data for the record with the latest date

    Christopher Antony

      I have applied a MAX Date filter to get the most recent record. What I also would need is to see historic data for this latest record.

      For Example , in the attached file Tim Pete has an entry for March 01, 2018 which is the most recent record in the data-set.

      when I filter on Max date I need to also view other records for this student. He has an entry on Jan 01, 2018 and December 18, 2017.

      What's the best way to approach this? I have tried LODs but I am not able to come up with a view I am looking for.


      Thanks for your help!