How to get top 5 rows of a selected column?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference b/w the refresh and buffered data?

1767


what is document design in boxi,have u participate in that

1667


Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

1493


How to create Index to the table in the universe designer and how it improves the Query performence

2130


If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

700






what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

9892


Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

641


What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

606


hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

1588


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

2613


How many universes can be created in a project?

603


(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

1003


can anybody tell me about complicated object you have created

2761


please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

1541


Explain what is the difference between business requirement document and use case document.

587