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...
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 |
Explain informatica architecture?
what are the limitations of cognos reportnet?
11 Answers IBM, Nestle, TCS,
What are the main services provided by application tier?
What is the difference between filter & Condition?
Can you define snapshot?
How can you improve performance in report studio level? What is the difference between Cognos sql and Native sql? How can you create cubes in framework manager?
7 Answers Genpact, iFlex, TCS,
Can i apply drill through on master detail relationship report?
What is the function of cognos dispatcher?
HI,can one suggest best institute for cognos Training in Hyderabad
-------------What is a Conformed Dimension?
how to hide a particular pages at time if you get blank pages
What is Lookup ,bridgeing tables where they will use in the Dataware house