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...

16. How can we create top 10 and bottom 10 records in
the same list?

Answer Posted / suman

ex. if we have a report with 100 records then

1.select a column which has measures(ex: quantity)
2.click on calculate ,select operationtype as analytic &
operation as rank
3.select the measure col, click on sorting
4.select the measure col, click on filters(in edit data)
5.select combine filters
6.add a filterline
7.select the range as from 1 to 10
again click on add a filter & set the operation as OR &
range from 90 to 100
click ok & run

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the considerations regarding performance kept in mind while setting up cognos?

972


Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance

2128


New coloums are added in database, then how you know in report level

1560


how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

1928


What is the difference between a data mart and a data warehouse?

1046


what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these

2026


What actually a project contains?

1099


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

2547


hi friends pls forward impropmtu interview question

2133


how to connect datamarts

2800


What r the names of the reports that you prepared?

983


hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1937


How do we drill through from a powerplay cube to reportnet?\

2357


How to create model and how to test model?

1029


faq's on cognos

4053