16. How can we create top 10 and bottom 10 records in
the same list?
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 create cubes in transformer ?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
What do you mean by Drill down and Drill Up?
Explain the characteristics of cognos?
New coloums are added in database, then how you know in report level
What is set to be cardinality?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
What are the components of the report studio?
which type of project we r going to snowflake schema
tell me two or three issues from client side and how to solve those issues?
What are the advantages of using cognos sql?
Can you define cognos decision stream?
What are slice and dice?
Why cognos decision stream is used?
Explain is there any comparison available for cognos reportnet vs crystal reports?