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
- 5898 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 |
Use of Text Source Variable in Report Studio?
What is Fullouterjoin?
Tell me about Dnamic and Static Dashboards?
Can we use 2 packages in report studio at a time is there any alternative for this Thanks Nithin
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
Why Star Schema is de-normalized? Please explain in detail probably with some examples.
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
how many facts and dimensions in ur project and query items,how u deliver ur report to end users..i am going with fake exp...pls ans me generally what to ans..
difference between drill through and master detail report?
how many facts&dimensions tables in project? it's very urgent.........
How Metrics Studio is better than Report Studio?
can we insert list report in corsstab report?
Teradata 
