How to select top 5 data from a dataset

[#1]

Hey People,

I want to create a table containing top 5 say 'drugs' based on total sales..How do i do that without making any change in the database?

[CELAMBARASAN]

Hi,

Try with rank function

     Sum({<Drugs={"=Rank(Sum(Sales))<=10"}>} Sales)

Or

=IF(AGGR(RANK(SUM(Sales)), Drugs) <= 10, SUM(Sales))

Celambarasan