Showing Straight Table Fields for Max Values

[MM]

Hello Everyone,

I am working on a straight table and I have a problem :

I have many fields :
- Vehicle Name
- Issue Number
- Type of issue
- Description of issue
- Start Date
- End Date

For every vehicle, I want to show each field for the max Issue Number of the max End Date.

Can someone give me a hand ?

I have tried with AGGR and FirstSortedValue, but no success.

Thank you.

[hopkinsc]

have you tried (aggr(max(date(EndDate)),VehicleName,IssueNo, RESTOFDIMS))

[MM]

Thank you for your quick reply.

This will work to display the Max End Date for each Vehicle.

But how to show the Description of an issue of the Max End Date for each Vehicle ?

[MM]

It should be something like this :

= FirstSortedValue ( DESCRIPTION, -aggr(Max(END DATE), TYPE OF ISSUE, VEHICLE NAME) )

But it doesn't work.