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
How do you call a store procedure within a transformation?
What are all the advantages of Cognos?
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
What is the metric store database?
What is the difference between ‘macro’ and ‘prompt?
Can you define drill down and drill up?
What actually a project contains?
Explain the characteristics of cognos?
Why need staging area database for dwh?
What is the function of cognos dispatcher?
hi my name is siraj i want to know cognos queriy language
faq's on cognos
When we save a report in report studio with what extn it save?
------------------What is Inline Query?
What are the main services provided by application tier?