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

    Ranking Issue

    Alec Harf



      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')


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

      ([Date] - [Date_]))



      Anyone knows how I can do rank for all dates?