Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have one expression to show top 5 items.
= concat( if(aggr(rank(sum(Sales)), Item) <=5, Item), chr(10), aggr(rank(sum(sales)), Item) )
I want to use 1 identifier to it always works on full data set and do not get impacted by any selection.
I tried
concat( if(aggr(rank(sum({1}Sales)), Item) <=5, Item), chr(10), aggr(rank(sum({1}sales)), Item) )
but it dos not work.
How to do that?
Regards,
Jean
Try this also
concat({1} if(aggr(rank(sum({1}Sales)), Item) <=5, Item), chr(10), aggr(rank(sum({1}sales)), Item) )
Or
concat({1} if(aggr(rank(sum({1} Sales)), Item) <=5, Item), chr(10), aggr(rank(sum({1} sales)), Item) )
Regards
Anand
Hi,
Try this.
concat({1} if(aggr(rank(sum(Sales)), Item) <=5, Item), chr(10), aggr(rank(sum(sales)), Item) )
Regards,
Kaushik Solanki
Try this also
concat({1} if(aggr(rank(sum({1}Sales)), Item) <=5, Item), chr(10), aggr(rank(sum({1}sales)), Item) )
Or
concat({1} if(aggr(rank(sum({1} Sales)), Item) <=5, Item), chr(10), aggr(rank(sum({1} sales)), Item) )
Regards
Anand