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 |
5.what is LOV? where it is store?
How to execute the MACRO through Infoview?
What is #refresh,#hash,#Comupation error and How to resolve #refresh,#hash error.
Iam having an report it contain n number of rows i want to desplay each rows in one colur pls explain me its very important
which is the best way to resolve loop context r alias why?
What is the aggrigate navigation ? can anybody explain me with some practical example?
How to create Universe using Flat file in BO6.0
in universe perameter u dont give the option multiple contexts ,what is the impact in report level
Why do we need metrics and sets?
How many universes are required for a single project,and how many reports are required for a single Universe.
how to connect the hyperlink in webi reports?
I HAVE MONTHS AS DEC,JEN,MAY,APRIL... WHICH PROMPT IS USED TO GET REPORT IN SEQUENCE?