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 15464How to convert and use 10mm dia steel 150mm spacing instead of 12mm dia steel which is spacing?
3 29692I have 5 different country names and their currencies like India-Rupee, USA-Dollar etc. when I run the report, the report should display only either currencies or country names.How to run the report?
3 7725The customer would like to know about his 15days transactions[like 1st day - 15th day]. how would you do this?
2 6295Post New L&T Interview Questions
How many clients can I connect to an AP?
What is the function of the osi session layer?
What are the 3 types of numbers in python?
How do you fetch your website in google?
what is object-oriented programming in java?
What is the breakable method in scala?
Why is R Good for business?
Illustrate briefly about the different types of statement
how to find the cement bags and sand requirements for the one square meter of internal,external,ceiling plastering by using the various ratios like 1:3,1:4,1:5,1:6
Why do we need HTML 5 server-sent events?
Which type of salary is the best in the sales industry – a fixed one or a salary based on incentives?
What is cold backup, hot backup, warm backup recovery?
What is the VOR in primates?
What is binomial probability formula?
Is microsoft excel a software?