4 Replies Latest reply: Jul 21, 2016 10:14 AM by Alec Harf RSS

    Ranking Issue

    Alec Harf

      hi,

       

      I am trying to use rank function and the issue I have is it ranks each distinct value of the dimension and then start the rank again while i need to rank all the dimensions.

       

      Here is my dimension and expression

       

      Start Date: date(if(Flag_ = 1 , [Mature Date_]),'MMM YY')

      End Date: date(if(Flag = 1 ,[Date]),'MMM YY')

      Price:

      (Sum({$<Flag = {'1'}>}[Price]) - above(Sum({$<Flag_ = {'1'}>}[Price_])))/

      ([Date] - [Date_]))

       

       

      Anyone knows how I can do rank for all dates?

       

      Thanks,

      Alec