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


      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