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
- 3515 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 defined as Query studio?
I would appreciate if any one answer for this, I have faced the question like this, the question was Tell me some complex reports, which u faced?
how u publish the packages in framework manager
Define dimensions?
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.
plz anybody help me, how many reports we can create in one project?, and what are the names?in real time project at first what we will do?
When we save a report in report studio with what extn it save?
Define query items?
how to merge 2 crosstabs thans
how you create security to cubes ?????
can we insert list report in corsstab report?
wHAI IS THE DIFFERENCE BETWEEN LIST REPORT AND CROSSTAB REPORT?
Teradata 
