4 Replies Latest reply: May 1, 2012 12:14 PM by knguyen1 RSS

    Using Text in chart to display last data point on line chart

      Hi All,

       

      I am trying to display the last data point value from my line chart to a text in chart.  But I do not know how to reference the last data point in the text in chart expressive.  My dimension is [Date] and my expressive is [MV], where [MV] is "=if([Date]=vStartDate,($(vAmt))*(1+[Return]),(above([MV])*(1+[Return])))"

       

      I don't think set analysis work with the above function. I try using the below expressive with no luck:

       

      =(Sum({<Date={"=$(=Max(Date))"}>}[MV]))

       

      [MV] is the label for my vMV expressive column, I don't need to sum.  I just need to somehow reference the value of [MV] where Date=max(date)

       

      Thanks.