Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
Try with rank function
Sum({<Drugs={"=Rank(Sum(Sales))<=10"}>} Sales)
Or
=IF(AGGR(RANK(SUM(Sales)), Drugs) <= 10, SUM(Sales))
Celambarasan