BusinessObjects Board

Webi Rank function

building reports webintelligence
#1

Hi,

I have more than 10 products and by Year I have the count of each products.

Year|Product|Count
2000|Prod1|50
2000|Prod2|3
…
and so on…

If I want to show the Top 5 products in a particular year, I know I can use the ranking option.

But using the ranking option will only show me Top 5 Products (if I set to top 5).

What if I want to show the next row as ‘Others’ (and show the count of other Products that are not in the top 5)? Is there a way to go about it?

Thanks in advance.

#2

A search for ranking and others leads to plenty of results:
https://bobj-board.org/search?q=ranking%20others

One of those should sort you out for your scenario

#3

Hi MarkP,

Thanks a lot for the link.