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.