hi How Can we create rank in our report?i feel difficulty
pls expain me with ex,pls pls........
Answer Posted / srini madhala
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 |
Post New Answer View All Answers
What are slice and dice?
what is the procedure for scheduling conditional rendering?
Which studio is used to create reports?
What is difference between page break and section report?
What is a Query Subject?
Can you explain new content durability?
How we check the errors before running the report?
What are the types of hierarchies?
What do you understand by the term 'model durability'?
Explain about scorecarding?
Why cognos decision stream is used?
What do you understand by ‘ibm predictive maintenance and quality’?
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
What are products of cognos?
What you mean by drill across?