Sample Data
Loan# Event_Code Date
1111 100 6/1/15
1111 100 6/2/15
1111 141 6/19/17
1111 152 6/21/17 /*keep*/
1112 100 6/19/17 /*keep*/
1113 100 6/5/17
1113 112 7/10/17 /*keep*/
1114 100 8/1/16 /*keep*/
In my cognos query I need to be able to choose the last instance of the event_code by loan# and the date, while deleting the others. How can I accomplish this???
Hi,
create data item like below
[maxeventcode] with the expression maximum([event_code] for [loan#],[date])
and add a filter
[event_code] = [maxeventcode]
Good luck
New guy