It would be great to have a "most recent" option in the calculated field, as a different option from min, max and average. It would be particularly useful for date driven records.
If I understand what you're asking, this should work:
Looking forward to it
Any workaround for this?