help needed on rank()

[#1]

Hi All,

Hope all are doing good..

i need help on regarding rank().

i have month,sales,country fields and in a line chart i need to show top 5 countries sales(5 lines) against month dimension.

for first expression i need to show top country sales over month and for second exp i need to show second top country sales like this i need to display for top 5 countries.

please help me with the expressions.

Thanks in advance,

Nani.

[swuehl · Accepted solution]

I assume you want to rank after total sales, not per month (latter should not work really good in a line chart).

Use month field as 1. dimension, then country field as second dimension and as expression

=Sum({<country = {"=Rank(Sum(sales))<=5"}>} sales)

[#3]

thanks swuehl for the solution.your expression fulfilled my requirement.

thanks for correcting me.