Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to show the top ten in one chart and the bottom ten in another but for some reason the top ten shows minus amounts. I've tried using dimension limits to show only first 10 and show only values that are greater than 1 but both are showing -.
Any ideas how I can do this?
CC
Hi,
Try like below for Top 10
1) Using Set Analysis in Expression
Dimension = Product
Expression
Sum({<Product = {"=aggr(Rank(Sum(Sales),4),Product)<=10"}>} Sales)
2) Using Calculated Dimension
Dimension = use cal.dimension
=aggr(if(Rank(sum(Sales),4)<=10,Rank(sum(Sales))),Product)
for bottom 10
=aggr(if(Rank(-sum(Sales),4)<=10,Rank(-sum(Sales))),Product)
Thanks,Deva