Skip to Content

Sorting/Ranking of Others in Top 5 ranking


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


Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

0 Answers