How to filter out rows on straight table?

[kevincase]

I have data that has Id, Condition, Status as Dimensions with Date and Time as Dimensions.  I need to display only the latest entry.  This needs to be done in the front end, not in script.

For example,

Straight Table:

Desired results:

Any ideas?  Thanks!

[idogridish2]

Hi,
create a new dimension in the script Date+Time as DateTime,

then in the table' insted of Date field create a calculated dimension:

=Aggr(Only({$<DateTime={"=Aggr(rank(DateTime,4),ID,date,time)=1"}>}date),ID,date,time)

then uncheck "Include Null Values"

i am attaching an example.

BR

[kevincase]

BR,

Thanks for the quick response.  Unfortunately, I can not modify the model/script to include a new dimension.  Business dictates that the date and time need to be separate dimensions.  This is why I was looking to do this in the 'front end' only so performing set analysis is not possible.

Thanks for the effort!

Kevin.....