Skip to Content
0
Former Member
May 15, 2008 at 03:15 PM

Filter Oldest Entry for Each Record

20 Views

Post Author: Stephanie

CA Forum: Desktop Intelligence Reporting

I have a file that has multiple rows for each record, each with a different date. I would like to filter the report so that only the oldest entry for each record appears. Any suggestions? The report looks like this:

Record 1 01/01/07

Record 1 03/01/07

Record 1 05/01/07

Record 2 03/01/07

Record 2 05/01/07

Record 2 07/01/07

I would like the report to show this:

Record 1 01/01/07

Record 2 03/01/07

Thank you.