hi How Can we create rank in our report?i feel difficulty
pls expain me with ex,pls pls........
- 2 Answers
- 4817 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / annareddy
If u find the top 5 sal :
Create quires with Product type, Quantity, create Rank
column with rank(quantity)
Query1 give filter Rank<=5
Change the filter Application property from Before Auto
Aggregation to After Auto Aggregation.
| Is This Answer Correct ? | 2 Yes | 0 No |
Think you have 4 dataitems in report, 1 column as salary.
So if you to find top 5 salaries then:-
rank(Sal)- Ranking Displays the ranks of the salaries based on there values.
running-cont(rank(Sal))-Top provides you the top salaries and least salaries. For example to show top5 salaries.
top<=5 display top5 salaries
| Is This Answer Correct ? | 0 Yes | 0 No |
How to do Performence Tunning in Cognos Reports?
can we put more measure on cross tab? If so how many? How this affect the aggregation?
What is difference between primary key and unique key constraints?
What are the types of hierarchies?
how many types of formats you can run a report using cognos?
How can we create a dynamic column name in cognos?
Can you define report item?
You get a parsing error when you run a report. What will be your first steps to resolve the error?
How to add 2 different colors for alternative rows? i.e in a report all rows colors in alternative colors(2 colors)
cognos reportnet is molap or rolap ... somebady telling cognos reportnet is molap and other will be telling rolap ... i need extract answer
What are the other methods working as deployment functionality?
What is a Framework manager?
Teradata 
