1 Reply Latest reply: Aug 4, 2012 6:06 AM by Stefan Wühl RSS

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

    brandon breitling

      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