Interested to Buy Any Domain ? << Click Here >> for more details...
hi How Can we create rank in our report?i feel difficulty
pls expain me with ex,pls pls........
- 2 Answers
- 6008 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 |
what r the filters in fwm and report studio
What is the difference between group and associare?
Hi all, i have a requirement in Conditional drill through. I have a list report with Cities India, UK, USA, China, japan, Canada.... In the above cities i want to give Hyperlinks(Drill) for Only India & UK. Could you please send me the steps????
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this
What is the disadvantages of using Database functions instead of using Cognos Functions in Report studio?
1 Answers Cognizant, Niteo, SacSoft,
Which service handles requests for cognos connection,query studio and event studio.
how to access the database directly from cognos reportnet
What is the difference between the standard and metrics folder?
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
Can you define cognos decision stream?
How do we drill through from a powerplay cube to reportnet?\
actually my qus is i used some tables in my model,i published that to connection i use that one.at the same way my team member added some new tables and again he published how can i get my model in connection pls pls explain me..........
Teradata 
