Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Look into FirstSortedValue, which could solve your request, like
=FirstSortedValue(Status, -DATES)