It is possible to give 2 query items has measures in cross
tab?for ex:row as products,column as year and measure as
revenue,sales year....like that.It is possible r not ?If it's
possible pls tel me the process....
- 2 Answers
- 4109 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / naresh
Yes it is possible, drag and drop the measures what ever you want into under Year column. now it is working fine..
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rao
Yes it is possible, we can drop many measures in cross as many we want.
For this, you can drop revenue under year and after this you can drop sales (2nd measure) on right side or left side of revenue when black cursor blinks.
you can drop other measures also in this way.
Hopes it will help.
| Is This Answer Correct ? | 0 Yes | 0 No |
Due Date (Highlight Issues in Blue where Due Dates are less than Todays Date),I have only Due Date column then how to over come the problem.How to find out which Due Date are less than Today Date...Kindly provide the detail steps to my mail ID-->asimcognos10@gmail.com
Hi, I am Searching on Cognos 8, If any experienced person can send out a project or explain a realtime scenario that would be very helpful for me. Please be kind towards me and help me in this regard. I am really finding difficult to find a person who can guide me in this feild. Your help will be highly appriciated. My email id is balajishriram@gmail.com. Hope you will help....
It is possible to give 2 query items has measures in cross tab?for ex:row as products,column as year and measure as revenue,sales year....like that.It is possible r not ?If it's possible pls tel me the process....
What is the use of cognos decision stream?
what type of charts we create mostly in realtime? plz help
Explain the different types of views used in cognos.
what is the difference between aggregation and roll up aggregation?
16. How can we create top 10 and bottom 10 records in the same list?
What is the difference between macro & Parameter
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?
What is the difference between static and dynamic conditions?
Teradata 
