Skip to Content
Enable Trend Reporting – by Manipulating Variable value Summary Scenario is pretty simple, Trend Analysis – User enters “Key Date” and is interested in analyzing Key figure values under various heads. For example user enters “Current Date” and is interested in looking at the “Sale on Entered Date”, “Sales for Current Month to Date”, “Sale for Current Year to Date” and also these values for previous year and many more. Scenario presented here takes you step by step (including ABAP Code) to enable this kind of reporting. Overview This particular assignment was meant for Senior Sales Manager, who was interested in looking at the “Tree” (almost current status) and “Jungle” (longer horizon) at the same time. Needs were to analyze the following analytics on “Key Date”. “Key Date” is decided at the runtime. Few of the analytics covered were- # Sales on Day – On the “Key Date” decided at the run time (User Entry). # Month to Date (MTD) – From the 1st of month to “Key Date” – for current year. # Average Month to Date – MTD divided by the “No of Days” in month till “Key Date” for current year. # Previous Year Month to Date – MTD for the Previous Year. # Average Previous Year Month to Date – Average MTD for the Previous Year. # Year to Date (YTD) – From the 1st to entered “Key Date” for the current year. # Average Year to Date – YTD divided by the “No of Days” in year till “Key Date” for current year. # Previous Year to Date – YTD for the Previous Year. # Average Previous Year to Date – Average YTD for the Previous Year **** READ THE APPROACH AND SOLUTION AT ***

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. Anonymous
    What would be really cool is to extend this solution to calculate business days in the ‘month, period, quarter, year’ by interpretting the factory calendar. As an example, the 3rd of the month could be the 1st or 2nd business day depend on where the weekend falls.
    (0) 

Leave a Reply