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 is looping and how to avoid it in framework manager?

1206


how to connect datamarts

2791


what are the features in cognos8ui

2048


Can you define metrics designer?

1056


We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?

2525


What is dtm?

1169


How can we create a dynamic column name in cognos?

956


Can you define cognos powerplay?

1094


What is a dimension?

1032


What is the difference b/w macros and prompt?

1132


tell me two or three issues from client side and how to solve those issues?

2167


What is difference between informatica power mart and power center?

1004


Can you define cognos decision stream?

992


Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?

2047


What r the names of the reports that you prepared?

981