Finding the newest value

[#1]

Hi,

I have a simple table consisting of 3 fields (Container, Status and reload date). Every day the table is expanded with an extra day.

I would like to make a object that shows me the newest status for each container.

See attached file for details.

The result should be:

Container      Status

A                  1

B                  3

C                  4

Thanks.

BR

Jakob Hjorth-Hansen

[jagannalla]

D V,

Your blog is really good. Today i learned the concept of FirstSortedValue, Thanks to share with us.

[IAMDV]

Jagan,

Thank you for the kind words. I'm glad you have learnt something new. Please can you email me directly at dvadithala@gmail.com.

Cheers - DV

[#4]

I have seen your site many times and I have learnt so much from there. what a Gr8 work you are doing

thanks to sharing

- IndianQvLover

[IAMDV]

Jakob & All - I understand that we have already got this working by FirstSortedValue() function. But I thought it will be good to use Set Analysis with Indirect Analysis.

MaxString({<[Reload date] = (P({<Status ={$(=max(Status))} >}))>} Status)

Cheers,

DV