Rank function in expression

[marishnagendran]

Dear All,

Raw Data:

Product	Sales
A	100
B	200
C	300
D	50
E	100
F	150
A	100

In Chart Expression Dimension as product and Expression as Sum(Sales)

Product	Sum(Sales)
A	200
B	200
C	300
D	50
E	100
F	150

My Requirement top 3 products in chart using rank function in expression is there any possibilities???

My Output is

Product	Sum(Sales)
A	200
B	200
C	300

[sunny_talwar · Accepted solution]

Try this expression

Sum({<Product = {"=Rank(Sum(Sales)) <= 3"}>}Sales)

[lironbaram]

hi 

you can do it with no need to another expression 

you could go to the dimension and set it to display only 3 values 

and it'll display to you the top 3

[marishnagendran]

It's not working ....

[marishnagendran]

Yeah i Know but for my customization i need in expression level

[sunny_talwar]

It is working for me

[Channa]

=If(Aggr(Rank(Sum(Sales)),product)<=3,Product)

it is ur dimension

measure :Sum(sales)

[marishnagendran]

Yeah It's working...but inside rank function my current year expression is not working

FiscalYear = {$(=Max(FiscalYear))}

[marishnagendran]

Now it's working thank you