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 15548How to convert and use 10mm dia steel 150mm spacing instead of 12mm dia steel which is spacing?
3 29840I 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 7844The customer would like to know about his 15days transactions[like 1st day - 15th day]. how would you do this?
2 6390Post New L&T Interview Questions
What is data modeling and data mining?
How can we calculate cable size in Low voltage & high voltage
How will you to create a pie chart in vf page?
How is a loop recorder monitored?
Differentiate between absolute and related path?
What are the different kinds of test steps?
what is asymmetrical protocols? : Client server computing
Why are migrations necessary?
How to handle browser (chrome) notifications in selenium?
Suppose the production is more and sales less then what will happen
What is meant by counting classes?
What is meant by managed and unmanaged code?
How is security handled?
What is the servlet container life cycle?
Consider the scenario – if the calculation1 have exception and it goes to recover and the calculation2 also have exception, what is the correction in this flow to go thru end stage without exception.