Show text value for latest date

[#1]

Hello,

I didn't find the answer for my problem on the forum, so I would like to ask for help on that...

I need to display value from maximum (latest) date. I have data as following:

Date	Value
2012/12/31	Medium
2012/11/30	Large
2012/10/31	Small

I would like to display 'Medium' in the text box as this is the value for maximum day in the data I have.

If anyone have the idea how to do it, please help me, cause I'm running out of the ideas on my own .

[swuehl · Accepted solution]

Try FirstSortedValue() function:

=FirstSortedValue(Value, -Date)

as expression in a textbox. Date should have an unambiguous Value for the latest date, and Date field must have a numeric representation.

Hope this helps,

Stefan

[#3]

Thank you for a very helpful answer .

Now I have a new problem: how to display text value for latest month -1 (according to the table I have attached: 'Large'). Could you please advise... It's more complicated I think.

[#4]

And now I will answer myself

FirstSortedValue(Value,-Date,2)