Skip to Content
0
Apr 05, 2011 at 10:18 AM

Top 5 using ranking

1010 Views

Hello ,

I have situation where i have to show TOP 5 material depending upon Quantity Sold.

Mean only 5 entries (5rows).

Now i have materials which have same value for Quantity Sold , so cant able to restrict to 5 rows

even after using both rank function or Ranking Option(button) .

I have only one dimension to set ranking ON.

Can you please help me in displaying only five rows of TOP 5 .

Thanks in advance

Regards,

Kamal