Unique rank

[Anna711]

Hello,

I have an issue with the "rank" function. I have a list chart that should display top 10 countries by sales. I created a new data item "Rank": rank(total([SQL1].[SALES])) and sorted the table by "Sales" desc. The problem I encounter is that when there are a few countries with the same sales amount, I receive more than 10 rows (cause the functions gives them the same rank). How can I have a unique rank?

Thanks!

[Satheesh]

Hi,


Use Running-Count() function and filter on that Data Item....
Use Filter [DataItem1] <=10


DataItem1

running-count(sales)

[Anna711]

Thanks for your reply. I tried running-count and for some reason now it only shows 1 row...

[Satheesh]

Hi Anna,
Select running-count Filter
In Properties ( Right Side) ---> Under General ---> Application change to After Auto Aggregation..




You can get

[Anna711]

Thanks a lot! It seems to work now.

[Satheesh]

 Your are Welcome  ;)