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
- 15433 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 apply securities for reports in cognos connection?
Where do you edit cognos sql in report studio?
what is model and say about process how to create model and how to test model?
what is degenerate key in oracle ?whare do we use it?
What is diffence between query calculation and layout calculation?
what is an associated query?
What is a Folder?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
How can we improve performance in framework manager level?
what are typees of dimensions
what is the difference between group span and level span
I have a report with list and cross tab in same page,How do you restrict one user can see only the list and other user can see both?
Teradata 
