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

actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....

1451


What are the message flows?

727


Why is auto-regression used in forecasting used on cognos platform?

718


What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?

923


how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?

8576


----------------Describe DWH Architecture?

1827


How create measures and dimensions?

788


Explain the difference between powerplay transformer and power play reports?

763


WHAT ARE THE DISTNICT VARIABLES?

1948


what are slowly changing dimensions? Why we are used scd?

788


What are various types of gateways in cognos?

725


What are all the types of gateway used in Cognos?

716


How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?

3026


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

1758


7. What is performance tuning?

1752