Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

hi How Can we create rank in our report?i feel difficulty
pls expain me with ex,pls pls........

Answer Posted / srini madhala

Think you have 4 dataitems in report, 1 column as salary.
So if you to find top 5 salaries then:-
rank(Sal)- Ranking Displays the ranks of the salaries based on there values.

running-cont(rank(Sal))-Top provides you the top salaries and least salaries. For example to show top5 salaries.
top<=5 display top5 salaries

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to create cubes in transformer ?

1119


What is the difference between a cascading report and drill through report?

1117


How create measures and dimensions?

1136


what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw

2370


What are the two types of framework manager?

1432


how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?

9317


What is the difference between the standard and metrics folder?

1018


how to perform back drill through in cognos 8 what is the use of it

2613


-----------With out using DrillThrough how to do Reports?

2092


What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?

997


how u burst the reports? if u r bursted reports is not reached to destination how u identify???

11850


Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?

1019


hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2415


How to publish a package by running Java Script?

2131


whats the difference between previous version of cognos and cognos 8 BI?

5618