Get expression for latest date

[Anonymous]

ex. Loaded table

Week, value

week 1, 2

week 1, 3

week 1, 1

week 2, 1

week 2, 3

week 3, 1

week 3, 2

I want to get : sum(value) for most recent week (i.e. "week 3"); I suspect a combination of aggr() and firstsortedvalue() should do the trick, but I can't nail it down.

Thanks for your help.

[tresesco · Accepted solution]

=Sum({<Week={"$(=MaxString({1}Week))"}>} Value)

[Anonymous]

Thanks, Set Analysis was the answer.