Interested to Buy Any Domain ? << Click Here >> for more details...
16. How can we create top 10 and bottom 10 records in
the same list?
- 9 Answers
- 36477 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / venu
for example if u want to create top ten employees who are
generated max revenue then add new dataitem with expression
rank(total(revenue) for employeename) and in filter
deffination dataitem<10 then u will find top ten records
and for bottom ten records add rownum to column and make
desending order nuw filter for 10 records thats it okayyyyy
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
How can I schedule reports in cognos?
What is looping and how to avoid it in framework manager?
How to join multiple db in catalog?
What is a Datastore in Cognos?
Can you define transformer?
what is requery in cognos?
What is difference between informatica power mart and power center?
Which lifecycle we will use for reporting?
What are slice and dice?
How do we convert from Numeric to be Words?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
What do you mean by drill across?
How do we drill through from a powerplay cube to reportnet?\
what is a prompt value in report studio and variables ?
What is the use of powerhouse?
