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 |
What is Universe?
in BO module, you forgot all password even all user in business object, designer, supervisor, gen.supervisor everythicg, how to you recover your datas?
What is difference between merged dimension and forced dimension??
WHAT DOES SQL TAB CONTAIN?
What is casual dimension?
what is fantrap ?
How many universes are required for a single project,and how many reports are required for a single Universe.
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?
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.
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
what is canned universe and canned reports in bo?
what problems you have faced while creating an universe ? tell me an incident and how you went about solving it? thanks in advance