Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i have a scenario like below can u please help us
any chart(ex : bar ) should show top 5 and bottom 5 sales
both(top and bottom 5) should show in a single object
thanks in advance
regards
siva
create a custom dimension like below
=If(Aggr(Rank(Sum(LineSalesAmount)) <= 5,SalesPerson) or Aggr(Rank(-Sum(LineSalesAmount)) <= 6,SalesPerson),SalesPerson)
create a custom dimension like below
=If(Aggr(Rank(Sum(LineSalesAmount)) <= 5,SalesPerson) or Aggr(Rank(-Sum(LineSalesAmount)) <= 6,SalesPerson),SalesPerson)
Siva, did Dilip's post help, or are you still trying to sort things out? If the solution did work, please be sure to use the Accept as Solution button to mark it, so Dilip gets credit and others know it worked. If you did something else, consider posting that and marking it, and if you are still working on things, leave an update, so we can try to come up with other ideas.
Regards,
Brett