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 shortcuts? Where it can be used? What are the advantages?

987


What is called Cognos powerplay?

1025


Is it possible to join multiple Databases in a Catalog?

1059


what is model and say about process how to create model and how to test model?

996


how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?

2227


Define datastores in cognos?

884


explain how to create powerplay reports?

951


what are the features in cognos8ui

1987


faq's on cognos

3998


If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.

2045


Define query items?

958


What are all the types of hierarchies?

1076


All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me

2017


What are the roles defined by cognos platform?

1071


Write various indexes used in cognos?

920