16. How can we create top 10 and bottom 10 records in
the same list?
- 9 Answers
- 34784 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 to deploy from one server to another server?
2. What functional area you worked on.
What is the use of report studio?
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
explain how to create powerplay reports?
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
What is called a slice?
-----------Diff b/w OLAP and RDBMS?
How can we create a dynamic column name in cognos?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
What is a Query Subject?
What do you understand by the term 'aggregate advisor?'
What are the advantages of using cognos sql?
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
