Expression for dynamic label

[#1]

I have a field in my dates table called WeekNo, which is used as the basis for summing my data.  Also in my dates table I have a field called Rpt Wk.  Within this dates table, WeekNo = 260 corresponds to Rpt Wk = Sep Wk 5.  How am I able to write a dynamic label expression that uses the max WeekNo but returns the Rpt Wk field value?  Thank you in advance.

[sunny_talwar]

May be this:

FirstSortedValue([Rpt Wk], -WeekNo)

[Anonymous · Accepted solution]

Hi Brian,

=MaxString({<WeekNo = {$(=Max(WeekNo))}>}[Rpt Wk])

Regards!

[#4]

Was able to get this to work, thank you!