5 Replies Latest reply: Feb 7, 2013 1:42 PM by Paolo Guidolin RSS

    FirstSortedValue or set analysis

    Paolo Guidolin

      Hi, I have this table

      Immagine2.bmp

      I need to create a pivot table with ProductType as dimension and in expression the value of status for the max(Date) of ProductType

      I try to use

       

      max({<Date={"$(=max(Date))"}>} Status)

       

      but the result is not correct. So I try to use


      FirstSortedValue(distinct Status, -Date)

       

      But I'm not sure that it is the best solution.

       

      Help me on this...urgent

       

      Thank you