Limit rows on Top 5 ranking

[Former Member]

Hi

I'm on BusinessObjects Webi 4.1 SP4, and want to ask if it is possible to limit the number of rows to show when ranking are the same.  For example, this is the dataset:

Material        Quantity Sold

Material1             30

Material2             25

Material3             25

Material4             25

Material5             25

Material6             25

Material7             25

Material8             25

Material9             15

I want to get the results to show Top 5 :

Material        Quantity Sold

Material1             30

Material2             25

Material3             25

Material4             25

Material5             25

(I honestly don't care which items are selected displayed between "Material2" to "Material 8", as long as there are 5 rows)

Right now my Webi report is showing the following with the Top 5 Ranking:

Material        Quantity Sold

Material1             30

Material2             25

Material3             25

Material4             25

Material5             25

Material6             25

Material7             25

Material8             25

Would appreciate any thoughts and suggestions, thanks!

[nikhil_joy2]

Hi,

Try creating runningcount() of rank and filter the measure value. This column can be used as index for the table.

Regards,

Nikhil Joy

[jean_machado]

Hi, Select the Data Access tab Edit - Button View Script - Option Use Custom query script Soon after the select add instruction and top 5 at the end of the instructions include order by desc desired field. Click button and save Validity. Apply change and close. Run the query.

I hope this helps. hugs

[Former Member]

Please dont follow the previous solution it will show you only how to give the ranking.

You can do the following steps:

1) Sort your Data as 'Quantity Sold' Measure object.

2) Create variable

Custom_Ranking = 1+Previous(Self)

3) Just create report level or block level filter for measure 'Custom_Ranking' like

Custom_ranking less then or equal to 5.

Now you will get your desired output.

Thanks,

Swapnil

[Former Member]

Check if this link helps:

http://scn.sap.com/community/businessobjects-web-intelligence/blog/2014/02/18/webi-trick-top-n-data-...

-Ankush