Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4129 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 reprompt?
1.how do nyou configure link between fwm and database (source).if you created fwm where it will be? and if you create reports where it is stored? 2.what is spic shot in fwm?
Can we create a report in cognos BI without a Package? i.e. without framework manager? If so how? I have been asked this question twice..i think this feature is available in cognos 10 version..not very sure....Could anybody highlight?
how to get the all values from a prompt using 'ALL' use and display value in prompt
what is prompt types of prompt example briefly each types of product (eg:values, date,search,prompt etc.)
Can you define cognos powerplay?
Interval Prompt's Usage? Example for usage in Project
what is the difference between a data item and a query item?
How to do deployment?
what is a prompt value in report studio and variables ?
what is model and say about process how to create model and how to test model?
If anybody need certification dumps like COG-112 COG-122 COG-132 THEN MAIL ME ON kris.bi121@gmail.com.all are latest dumps test taken on july-09
Teradata 
