Skip to Content
0

Sorting/Ranking of Others in Top 5 ranking

Oct 19, 2016 at 01:47 PM

69

avatar image
Former Member

Hello,

I have a question concerning a ranking in a graph in BO WEBI. In this graph I want to show the top 5 Transportation lines (so far so good = no Problems).

Furthermore I also show all the other Transport lines (from 6 onwards) in this graph in Total (summed up).

Now to my Problem/question: the graph is ranked by a key figure and usually others would always be first, but I always have to rank them in number 6 (after the top 5).

Please advice how to achieve this.

=rank([Shipment PY %];[Country]) In ([Country])

=if([RankVar]<6;[Country];"Others") In ([Country]) = Category Axis

Thanks,
Marcel

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers