Ranking Issue

[alec1982]

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

[swuehl · Accepted solution]

Try

Rank(TOTAL YourExpressionToRank)

[sunny_talwar]

Where is your Rank expression?

[jyothish8807]

Hi Alec,

Its a bit confusion.

Why do you have two date as dimension ?

What is the difference between Mature date and Date ?

Can you share a sample app, then it will be helpful.

Regards

KC

[alec1982]

thank you all.. Stefan got it !