Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I know it is possible to report on top N items or bottom N items in a chart. However I want to report on 11th to 20th ranked items based on Sales value.
Hi Mayuran,
Have'nt tries this expression, guess this should be working:
aggr(if(Rank(total Sum(sales))>11,if(Rank(total Sum(sales))<=20 , Customer)), Customer)
Try like:
=Sum({<ItemID={"=Rank(Sum(Sales))>10 and Rank(Sum(Sales))<21"}>}Sales)