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 29686I 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 7719The customer would like to know about his 15days transactions[like 1st day - 15th day]. how would you do this?
2 6292Post New L&T Interview Questions
How to upload files in amazon s3?
How do you secure repository?
Which sub module of sap could make business areas obsolete and can one business area be assigned to several company codes? And what is z transaction?
Contact a system development program in your organization. Research how they analyzed their SYSTEM OF INTEREST (SOI), its OPERATING ENVIRONMENT, and their respective system elements. How was this analysis reflected in the SOI architecture?
What are the precautions to generate a report on DSO in sap Bi?
Explain RAID and mirroring?
Tell us about weakness and whether it has stopped you from excelling.
Is unix a kernel?
What is ngmodel in angular?
What is the procedure to apply research papers leading to get Noble Prizes? I have developed a new theory on Earthquakes and willing to get it published in some International Journals.Can any one guide me where and how to send my research papers for publications?
How do I add an rss feed to outlook 365?
what is corporate accounting?
What is 'gap insurance'?
What is the default scope of spring component?
How do you print only part of a string?