Enable Trend Reporting – by Manipulating Variable valueSummary 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 ***
