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

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  

---

what is a Galaxy Schema?

2 Answers   IBM,

---

how many facts&dimensions tables in a sales project?can any body name those dimensions and fact tables please

6 Answers   TCS,

---

what is cardinality that you can give to employee and department query subjects in framework manager?

2 Answers   HCL,

---

WHAT SHOULD BE DONE WHEN A REPORT RUNNING TIME WILL TAKE LONG TIME IN CONGNOS?

2 Answers   ABC Infotech, Virtusa,

---

We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?

0 Answers  

---

What is power prompts?Can somebody explain me.

2 Answers  

---

can reportnet supports cubes???

4 Answers   IBM, Wipro,

---

how to create average on totals of different departments employees salary...? consider we have 3 dept and in each dept 10-15 workers i need to get the totals separately for each dept and average of there totals..help me pls

2 Answers   Patni,

---

Explain informatica architecture?

0 Answers  

---

i am having a table having name cust_employee.i use this table in my model after i published that to cognos connection .i generate some reports. after that in my data base cust_employee table is changed to cust_emp.how can i get this table into my report.i again import and published means its time consuming,in simple how can get the changed table in to my model pls pls ans me....

2 Answers  

---

wat is called Model dimension?

0 Answers   IBM,

---