Calculate the Rank

[prabhas277]

Hi Experts,

I have 5 years data in my dashboard, now i want rank for the multiple years.
Ex: i have years like  2010,2011,2012,2013,2014  and their sales 10,20,30,40,50, resp.

now if click on 2014,2013 then i want get the rank for those years.how to get it?

Thanks in advance

[Anil_Babu_Samineni]

Is this you are expecting?

Without selection

With Selection

[prabhas277]

Thanks for reply

Can you please share the expression?

[Anil_Babu_Samineni]

Create straight table

Dimension is Year

Expressions are

1) Sum(Sales)

2) Rank(Sales)

Note: For filter you may take Year as List box

[rahulpawarb]

Hello Prabhas,

Refer attached sample application.

Regards!

Rahul