Rank function

[#1]

Hi everybody,

I try to create table like this :

|0-10% best customers|Number of customers|

|10-20% best customers|Number of customers|

|20-30% best customers|Number of customers|

..

For the first column, I was thinkg to use the rank function !

=if(rank(Aggr(sum(PRODUCT), CUSTOMER)) > 0.01*count(CUSTOMERS), '0-10% best customers', 'Others')

But when I use the rank function, I have an error.

Any ideas ?

Thanks !

[#2 · Accepted solution]

For information, function fractile() do this.

example :

http://www.qlikfix.com/2010/10/08/decile-analysis/