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
- 15434 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is called materialized view?
Define metrics studio?
What are the types of security?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
Can you define snapshot?
What are the themes in a data warehouse?
How create measures and demensions?
What is a Folder?
Can you define fan trap?
What is Metrics designer?
What are the types of studio?
Can you define query studio?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
What is the difference between drill through, drill across?
Can you define a query subject?
