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

Can you define set to be cardinality?

581


How to publish a package by running Java Script?

1593


what are the errors faced while bursting the reports and how to solve those errors?

1562


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

1865


What is meant by alternate drill down with ex?

620






How do you improve the performance of the Cognos Analytics report

530


What are all types of Batches?

570


Write various indexes used in cognos?

549


Cleared COG-112 with 100% score today. What next certification should i go for?

1411


hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

1547


what is the difference between filter and condition?

599


What are all the advantages of Cognos?

634


Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..

1744


Give me any example of semi and non additive measures?

553


What is Metrics designer?

589