Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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), ', ')
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), ', ')
Hi Sunny,
Perfect working fine
Regards, Deva