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
What are the main services provided by application tier?
What is meant by Reportstudio shortcut?
What is a Datastore in Cognos?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
What is the report studio?
What is the use of cognos decision stream?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate 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.. Give the advantages of cognos? What is called cognos reporting tool? What is the difference between regular dimension and
derminant? whats the difference between previous version of cognos and cognos 8 BI? What is Metrics designer? What is difference between informatica power mart and power center?