Remove duplication by latest transaction date...

[aviation001]

first time cognos user; trying to run a report with employee date to yield results all employees with pay transactions between certain dates got that part right; the result shows multiple entries for some employees; i would like to sort/filter the report to remove the duplicate entries with the understanding that i still want all affected employees represented on the report with the latest date.

how do is specify a filter/query to show latest date entry only for all employees.

thanks

 

[ict2000]

Try to add a second filter with the "maximum ... for" function like the following:

transaction_date = maximum(transaction_date) for employee_number

This should work in both Impromptu and Report Studio.