my table having data like this
year month revenue
2011 jan 100
2011 feb 200
2011 mar 150 like this
i want My report
2011 jan 100
2011 feb 100+200=300
2011 mar 300+150=450
like this for this where we specify the condition how will
specify? pls ans me pls...
- 1 Answers
- 3636 Views
- I also Faced
- E-Mail Answers
Answer / ramachandra
Hi,
You may get solution by using data item,here i can the procedure how to do it..
Step 1; drag required year, month,revenue to the report page
Step 2: pause on query explorer select query1 then drag data item into data items(it displays expression box) write condtion like "running-total ([revenue])" then test it press ok.Rename it as Total.
Step 3: then drag total(dataitem) to report page.
Step:then run the report .
-Ramu
| Is This Answer Correct ? | 12 Yes | 1 No |
What is a query set?
hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
why we r using report studio in webbased only and fm windows based only
What are the message flows?
how to add a new dimension in the powerplay transformer.i.e already we have devbeloped one cube. in that we want to add one new dimension cn anybody plese tell me the step by step procedure.
Explain the Difference Between Bursting and Scheduling?
This question is asking in many interviews,,,,, What is your challenging task in report studio? anybody pls tell me some 2 or 3 challenging tasks,,,,
What are initial page components of Cognos connection?
can we insert list report in corsstab report?
8. Can you use calculations in report headers and footers? How?
what are diff b/w cognos and business objects
Teradata 
