Rank function

[#1]

help combining Rank function, Modes for Cutomers and a Mix?

[#2]

Hi Joseph

You need 3 dimensions :

YEAR

=If(   Aggr(    Rank(   sum(SALES)) , YEAR , MIX )  <=5 , MIX)   /*  TOP 5 MIX BY YEAR */

=If(   Aggr(    Rank(   sum(SALES)) , YEAR , MIX  , CUSTOMER)  <=5 , CUSTOMER)  /* TOP 5 CUSTOMER BY YEAR & MIX */

Regards

JJ