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
- 15538 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 |
how to improve the report performance?
What are the differences between cognos 8.2 and cognos 8.4? Please help me..
Explain the difference between powerplay transformer and power play reports?
When You Import data into catalog You have complex columns names. How do you change the Name of those columns?
What is the basic relationship between measures and dimensions in transformer modelling
What is the use of content store in cognos?
--------------How to do Report Testing in Reports?
what is the difference between native sql and cognos sql?
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
----------0Diff b/w Report Functions and Database functions?
What is content store?
What are all types of Batches?
Teradata 
