Rank function

Mon, 26 Nov 2012 19:32:16 GMT

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 !

Re: Rank function

Tue, 27 Nov 2012 10:30:58 GMT

For information, function fractile() do this.

example :