Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
D V,
Your blog is really good. Today i learned the concept of FirstSortedValue, Thanks to share with us.
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
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
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