Hi SASKiwi, On creating Year column as 2016/17 and 2017/18 as part of data preparation I can achieve YTD for those years, but on selecting any particular month as a filter I want a column to give running total for that month, for example if I select June as Month then the YTD Column should give me a sum of April, May and June Sales, but it only gives sales for June Month as output. Can that be achieved using Relative Period or Cumulative Period, if yes please provide an example. I tried Cumulative Period as shown in the below screenshot, but it gives missing values in most for February and March months. (Please tell why it is not showing values for Feb and March as they are present in the data.) Also let me know if the same can be achieved in SAS VA 7.3 and how?
... View more
