Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 15544 Views
- L&T, I also Faced
- E-Mail Answers
Answer / naresh
HI All,
Follow below steps to achieve this
1) In Filter condition place the below condition (to_char([START_DATE],'YYYY')=to_char({sysdate},'YYYY') and [START_DATE] <= {sysdate})
2)Create one Derived colum as MTD and in Expression use below code
case when (to_char([START_DATE],'MM')=to_char({sysdate},'MM') and [START_DATE] <= {sysdate})
then [Quantiry] end
Next in properties if this column for aggrigate Function and for Rollup Aggrigate Function change 'automatic ' to 'None'.
3) create one more Derived column as YTD and in expression use below code
case when (to_char([START_DATE],'YYYY')=to_char({sysdate},'YYYY') and [START_DATE] <= {sysdate})
then [Quantity] end
here sysdate is oracle date function.
Thats it .
| Is This Answer Correct ? | 0 Yes | 0 No |
What you mean by drill across?
What are the methods by which it non-durable model could be changed into the durable model?
my cient has reports in java and the dw mart is there already, whether you will suggest for Cognos reports ?
what is session parameters? what is use?
What is Bitmap Index?
What do you understand by the cognos?
what is a bookmark? what concept we use in bookmarking? please tell me how to create bookmarks(with explore)?
what is physical layer and presentation layer?
Can you define dimension?
What is content Manager?
Can any one expalain the procedure for How to create a Mastr Detail Report in Cognos 8.3 ver?
I want to display popup menu or alter message in my report? How to you solve this problem? Give me the answer with example?
Teradata 
