16. How can we create top 10 and bottom 10 records in
the same list?
Answer Posted / arangaraj
Hi,
All are wrong.for ex. if u have list report with
region,staff name and revenue. if u want show top 10 and
bottom 10 performance based on the revenue, drag new data
item from tool box to query item box then expression window
will show in that type like
For Top 10 performance:rank([revenue]desc for [region])
and give name for new query item like Rank or anything.
then drag this new query item to the detail filter window.
then type [Rank]<=10.
For Bottom 10 performance:rank([revenue]asc for [region])
[Rank]<=10.
if u want any query about cognos don't hesitate call me
by mobile:9787642227
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
How create measures and dimensions?
What is difference between primary key and unique key constraints?
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?
please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.
What is Metrics designer?
dumps needed ASAP for - C2020-180 Cognos IBM Certification
what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?
Define query items?
i have one file i saved in csv how can i take these file into framework manager
what do u mean by bridge group? where we r using this one?
Tell me about Dnamic and Static Dashboards?
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
What is Bitmap Index?
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
What is set to be cardinality?