Application performance using RANK

[Dayna]

Hi All,

I have a rank calculation where I want to show the top 10 customers based on the sales quantity, my calculation is done as a dimension and looks like this to get the rank:

=aggr(NODISTINCT rank(sum(quantity)),customer)

From there, I then do an if statement on the customer name which looks like this:

=if((aggr(NODISTINCT rank(sum(quantity)),customer))

<= 10,

customer)

Due to the number of records in the system, this takes ages, and sometimes, does not run. What do you recommend? Have I approached this correctly?

Many thanks,

Dayna

[MK_QSL · Accepted solution]

Create a Table (straight or pivot)

Dimension

Customer

Expression

SUM({<Customer = {"=Rank(SUM(quantity))<=10"}>}quantity)