Hi,
I am working on aBI 7 BEx query, where I have completions data for every course and with respect to every employee ID.
If an employee has completed the same course 3 times with in a year or across years, I have 3 records with three different completion dates for the that course and for that employee.Ex, first completion date is 01/01/2011, second is 05/31/2012 & last date is 12/31/2012.
When I run the query , I am able to see all the three records with three different completion dates.
Now what I want is new key figure " Max Completion date", which will be 12/31/2012 for all the three records, next to completion date key figure on the bex query.
Please let me know , how I can achieve this functionality.
Thanks
DM