How to get top 5 rows of a selected column?

Answer Posted / bobj reporting

To get top 5 rows of a selected column you need to use
ranking.

Select the column then click on the "Apply/Remove Ranking"
button from the toolbar and select on "Add Ranking". In
ranking properties select Top and 5.

Remember: you can only assign ranking to a measure.

Is This Answer Correct ?    15 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What would you consider as your biggest achievement and why?

615


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

597


How to execute the plsql procedure from the report by clicking with mouse?

615


Explain how to execute the plsql procedure from the report by clicking with mouse?

597


What is a fantrap in business objects?

579






I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

2995


What is the profile and package?

1764


What is object stores?

583


Explain the difference between detect alias and detect context?

620


Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

550


Explain what is the difference between slice and dice and cross tab report?

605


What are the join problems comes appart from loop,chasm & fan Traps

1550


Explain about a tricky situation for which you found a very simple solution?

539


Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

543


Explain how we drill up week to month?

639