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

explain in detail about type 3?

774


What Is The Difference Between Oltp And Olap?

837


Explain what are the measure objects?

707


Explain what task is 98% of the required work of a business analyst?

767


Explain is it the job of a business analyst or systems analyst to draw the class diagram?

776






What Is Snow Flake Schema?

860


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.

3181


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1614


What are the steps to be taken to schedule the report?

714


Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

1745


What task is 98% of the required work of a business analyst?

751


what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

10272


Which command using Query Analyzer will give you the version of SQL server and operating system ?

4480


What would you consider as your biggest achievement and why?

779


Difference between zabo and webi?

831