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
- 3716 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 the difference between group and associare?
What are the themes in a data warehouse?
Whrer u can save the Report net documentation in our local system?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
where do we see the run time of the report ?
Can you define metrics designer?
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com
in reportnet how u burst the reports for every 5th day, 10 th day, 15 th day, 20 th day
I want to schedule the report as sysdate-1.....how to do
In Drill through, Reports are executing successfully when rename & run the created reports? Pls tel me the reason?
------------What is Slicer memberset?
What is the use of Excel files in Cognos8?
Teradata 
