Skip to Content
0
Former Member
Jan 17, 2013 at 06:00 PM

Filter for most recent date

293 Views

Hi All,

I have a report that simplified looks as follows

Member Number Date of Evaluation Evaluation Result

1 12/1/12 100%

1 11/1/12 50%

1 10/1/12 75%

2 11/30/12 60%

2 10/15/12 75%

2 9/15/12 80%

etc.

I want to filter based on the most recent evaluation date. The most recent can be any date so I can't filter based on a date range. I just need in the above example for the first row from each client to display. Any suggestions?

Thanks,

Mike