Want to know value in field when another is at maximum for current selections

[#1]

Hi community,

I have a straight table that has dimension 1 and expresion 1.

The expression I want is the value in one field when another is at is max for the current selections.  Anyway I can do that?  The dimension is neither of the fields in the expression so something like:

if(date#(DATES)=max(total DATES),Status/100) doesn't work because Dates isn't my dimension

[swuehl]

Look into FirstSortedValue, which could solve your request, like

=FirstSortedValue(Status, -DATES)