How to get top 5 rows of a selected column?

Answers were Sorted based on User's Feedback



How to get top 5 rows of a selected column?..

Answer / 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

How to get top 5 rows of a selected column?..

Answer / manasa

To get top 5 rows of a select column we use ranking option.
In our report after running the document goto toolbar ->clink on ranking option ->under these tab enable top button ->click on ok-> observe the result

Is This Answer Correct ?    2 Yes 0 No

How to get top 5 rows of a selected column?..

Answer / gowthami

Create a new column and Implement the rank logic<(rank(measure column)>. after that use filter conndition where rank <6 then it will display the top 5 rows of the selected column

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Business Objects Interview Questions

What is Universe?

1 Answers  


in BO module, you forgot all password even all user in business object, designer, supervisor, gen.supervisor everythicg, how to you recover your datas?

1 Answers   iFlex,


What is difference between merged dimension and forced dimension??

1 Answers  


WHAT DOES SQL TAB CONTAIN?

1 Answers   Polaris,


What is casual dimension?

4 Answers  


what is fantrap ?

5 Answers   Tech Mahindra,


How many universes are required for a single project,and how many reports are required for a single Universe.

2 Answers  


Can some one say abt "ALL" in prompt .. How to get the word "ALL" in the prompt along with the list of values? Plz give me the steps?

7 Answers   Accenture, Wipro,


I have one vertical table and in that table there are 10 rows. I want to add one row between 4-5 row. How it possible in WebI.

3 Answers  


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

0 Answers   BMC,


what is canned universe and canned reports in bo?

1 Answers  


what problems you have faced while creating an universe ? tell me an incident and how you went about solving it? thanks in advance

3 Answers   Patni,


Categories