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