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
What are the considerations regarding performance kept in mind while setting up cognos?
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
New coloums are added in database, then how you know in report level
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.
What is the difference between a data mart and a data warehouse?
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
What actually a project contains?
how to perform back drill through in cognos 8 what is the use of it
hi friends pls forward impropmtu interview question
how to connect datamarts
What r the names of the reports that you prepared?
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
How do we drill through from a powerplay cube to reportnet?\
How to create model and how to test model?
faq's on cognos