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 15379How to convert and use 10mm dia steel 150mm spacing instead of 12mm dia steel which is spacing?
3 29460I 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 7574The customer would like to know about his 15days transactions[like 1st day - 15th day]. how would you do this?
2 6199Post New L&T Interview Questions
How do you write a file using node.js?
Can we import data from sourcesafe into sourceanywhere?
In which system does the output not affect the process in any way?
You want to configure the sap workflow to send a pop-up message to the approver when the purchase requisitions are ready for them to act upon. How will you do that?
What are the versions of html?
What is a variable product or configurable product?
What is WMLScript dialogs library?
What is the use of vacuum in postgresql?
Why session is not thread safe?
What is the use of 'using' declaration in c++?
What is a jbutton in java?
When JAVA will be mature ?
What is an i-server? What are the different modes to run it?
Did you learn anything new recently which can be helpful to bpo’s? : bpo
How to create TCP Server and TCP Client in node.js?