Concatenate top 5 Store

[devarasu07]

Hi All,

Using below expression able to get top selling store. but how to top 5 store ? any suggestion. Thanks

=Concat(DISTINCT Aggr(If(Sum(SoldQty) = Max(TOTAL <ArticleNo> Aggr(Sum(SoldQty), ArticleNo, StoreName)), StoreName), ArticleNo, StoreName), ', ')

Current Output,

Expected output like below,

Note:

tried like below and it's not working.

=if(aggr(rank(sum(SoldQty)),ArticleNo)<=5,

Concat(DISTINCT Aggr(If(Sum(SoldQty) = Max(TOTAL <ArticleNo> Aggr(Sum(SoldQty), ArticleNo, StoreName)), StoreName), ArticleNo, StoreName), ', ') )

Thanks,

Deva

[sunny_talwar · Accepted solution]

How about this:

=Concat(DISTINCT Aggr(If(Rank(Sum(SoldQty)) < 6, StoreName), ArticleNo, StoreName), ', ')

or

=Concat(DISTINCT Aggr(If(Sum(SoldQty) <= Max(TOTAL <ArticleNo> Aggr(Sum(SoldQty), ArticleNo, StoreName), 5), StoreName), ArticleNo, StoreName), ', ')

[devarasu07]

Hi Sunny,

Perfect working fine

Regards, Deva