I have Date,product,Quantity_Sold columns and I want Product, MTD(month Till date),YTD(Year Till Date) as output. Can anyone help me with the logic in getting MTD i.e quantity sold from 1st of this month to till date (i.e. 01- 11-2013 to 26-11-2013) and YTD i.e QTD sold from 1st date of the year to till date(i.e. 01-01-2013 to 26-11-2013). Sample output model: Product MTD YTD

1 Answers   L&T,

---

1. Explain your project.

0 Answers   IBM,

---

Did you find any differences in bursting feature between reportnet 1.1 & cognos 8? what are the differences?

0 Answers  

---

What is the use of Tree Prompt? Where it is used?Pls give me a real time example?

1 Answers  

---

How to upgrade drivers in Cognos 8?

1 Answers  

---

---

What are the themes in a data warehouse?

0 Answers  

---

What is the size of the cube?

0 Answers  

---

fiscal year means what???

8 Answers   iFlex, iGate,

---

Can you define snapshot?

0 Answers  

---

What are the differences between Cognos 8 and Cognos 7.x version?

2 Answers  

---

what type of charts we create mostly in realtime? plz help

4 Answers   IBM,

---

What are the advantages of shortcuts?

0 Answers  

---