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
Can you define materialized view?
what is online view?
What do you mean by Drill down and Drill Up?
What do you mean by query studio?
What is a Framework manager?
faq's on cognos
what are the dimensions that you have in your current project?list them?
What is main advantage datawarehousing over oracle?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
What is meant by junk dimension?
How security is concerned with Reportnet? Explain its implementing steps.
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
Can you explain a cognos controller?
What is difference between informatica power mart and power center?