How to get top 5 rows of a selected column?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

how get the grand total in master-detail report?

1825


What is the difference between user and versatile user?

589


What is difference between webi and infoview?

623


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1437


What is the difference between slice and dice and cross tab report?

609






Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

606


Differences between business objects and web intelligence reports?

660


any difficulitis have you phase while creating bo reports and how did u solve it

3002


Give some information on report bursting?

573


Explain the data types present in bo and what happens if we implement view in the designer and report?

568


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


1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?

5989


Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

601


Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

1976


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