comparing customers and ranking

[#1]

Hi,

I was trying to  compare customers in specific year and show  the best 5 customers in terms of sales.

here is my script:

=if(aggr(rank(Sum({<Year = {'$(=Max(Year))'}>}Sales)),Year,Customer)=5, Customer)

it seems that scripts returns " the 5th" in rank instead of  " the 5 best customers". Any idea ?

thanks

[its_anandrjs · Accepted solution]

Try like below script

=if(aggr(rank(Sum({<Year = {'$(=Max(Year))'}>}Sales)),Year,Customer)>5, Customer)

Or

=if(aggr(rank(Sum({<Year = {'$(=Max(Year))'}>}Sales)),Year,Customer)<5, Customer)

Or

=if(aggr(rank(Sum({<Year = {'$(=Max(Year))'}>}Sales)),Year,Customer)<=5, Customer)

[MK_QSL]

IF(Aggr(Rank(SUM({<Year = {'$(=Max(Year))'}>}Sales),4),Customer)<=5, Customer)

[ashfaq_haseeb]

Hi try

below code.

=if(aggr(rank(Sum({<Year = {'$(=Max(Year))'}>}Sales)),Year,Customer)<=5, Customer)

Regards

ASHFAQ

[anbu1984]

Replace = by <=

=if(aggr(rank(Sum({<Year = {'$(=Max(Year))'}>}Sales)),Year,Customer)<=5, Customer)

[#6]

Thanks  a lot

Is there a way to sort out ?  Best customer highest in the list ?

[MK_QSL]

Create a new thread !