Getting the record to show only based on the maximum date

[gosoccer]

Hi everyone,
I have a unique situation. I'm creating a List in Cognos Analytics and populating three data elements.

ID       STATUS     DATE
1111       NEW     Dec 15, 2016 2:30 Pm
1111       SOLD    Dec 17, 2016 1:00 Pm

So what I need to show on the list is one entry as
1111       SOLD    Dec 17, 2016 1:00 Pm and not both entries.

Is there a way to use the Filter and MAXIMUM feature to show the data without programming in Framework Model to get only the most up-to-date.

When I drag to the list the three data elements, even after using the below Query Expression, I'm still getting both records.

"Go to the Toolbox tab, drag in a query calculation, and set the expression to be maximum([your date time field] for [your record id])"

Thank you for your time.

[Cognos_Jan2017]

set the expression to be maximum([your date time field] for [your record id])"

Try, as a Summary Filter, in your Query ...
[your date time field]=Maximum([your date time field] for [your record id])

HTH, Bob

[gosoccer]

This approach worked perfectly Rob. Greatly appreciate it.  :) :)

[Cognos_Jan2017]

Happy to help.

Thank you, Bob