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

How to hide objects or columns?

6 Answers   Infotech,


What are @FUNCTION?

4 Answers  


What is maximum number of promts we can give in a BO report?

1 Answers   Patni,


What is the difference between Thin client & thick client?

5 Answers  


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

0 Answers  






2 table is there , thats column is different name but data type is same, 2 tables values are same. how to you findout both values are same?

1 Answers   iFlex, Patni,


Difference between drill by and drill across with example?

4 Answers   TCS, WNS,


What is the difference between user and versatile user?

0 Answers  


I have the one Universe. I take the data from the Excel Sheet. Now i want to get the reports from the two.What is the process

2 Answers   Wipro,


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

0 Answers  


how many times can use the union operator in a report?

3 Answers  


WHAT ARE THE VARIOUS PRODUCTS IN BO?

2 Answers   Polaris,


Categories