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

-------------------What is Deployment?

2 Answers   IBM,

---

Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice

0 Answers  

---

can we put more measure on cross tab? If so how many? How this affect the aggregation?

4 Answers  

---

What is slicer & dicer ? what is sub session parameter ?

2 Answers   Cap Gemini,

---

Explain what is the difference between microstrategy and cognos reporting tool?

0 Answers  

---

---

What is Online View?

0 Answers   IBM,

---

Which one is better among Value and select & search prompts,in terms of performance?

2 Answers   L&T,

---

In one of my report i have one data item sales_amount. If this report is run by one user from india so the sales_amount should be display in indian repees(Rs.) format, if USA user then in dollers($), if UK user then In Pounds.Hou can i achive this? Please answer me.

4 Answers   Accenture, HCL, IBM,

---

It is possible with out same Queries(both Reports) we can build the drilltrough between them? and how?

1 Answers   HCL,

---

If you have a report with list and cross tab in the same page. How do you restrict one user can see only the list and the other user can see both.

4 Answers   IBM,

---

How can you schedule the report that it displays a day old data. (My answer was to create a view, but the lady wanted some other method).

1 Answers  

---

------------------What is Inline Query?

0 Answers   Cap Gemini,

---