How to get top 5 rows of a selected column?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Explain what is aggregate table and aggregate fact table ... Any examples of both?
what are the roles and responsibilities of BO Administrator ?
1 Answers OCS Infotech, TCS, Wipro,
bo 6.5 is a 3 tier architecture. Tell me the names of the tiers?
When N reports are scheduled for N users, How does the BCA process /know to which user the report needs to be sent?
what is crystal reports?how to migrate them?
How to get top 5 rows of a selected column?
7.what is data mart?
how we improve the performance of report and universe?
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
Which outer join is used in Merge Dimension. Diff between merge and auto merge dimension.
2 Answers Cap Gemini, Infinity, TCS,
I have all the below SAP – Business Objects Certification latest Dumps, I scored 100 % Score with these Dumps
How to make alternative rows red and green in WebI Report?