Hi, I have monthly sales data for 33 markets for 5 years, I want to calculate FYTD sales. For us the Financial Year starts from month of April and ends in March. e.g. FYTD for October 2017 will be sum of sales from April 17 to Oct 17. So I have to create a variable named as FYTD and corresponding to each month it will have FYTD sales. Can i try it using proc expand. --
... View more