For the current year cumulative value , I use running sum to calculated YTM amount for current year.
For the last year , I created 2 variable based on CALMONTH and tring to set then as where condition.
Var 1 2020/01 → ·2019/01 get YYYMM of last year
Var 2 2020/01 → ·2019/01 get YYYMM+2 of last year
VAMOUNT = AMOUNT WHERE ( CALMONTH BETWEEN VAR1 AND VAR2)
Then I append the newly created variable VAMOUNT under current year line , but it shows blanks.
It’ll be great help if someone could get me some hint about it. Thanks in advance.
Quick and dirty to show sample of how I would go about it.
1.) Create variable for year of your calmonth
2.) Create a variable for Month of your Calmonth (You may wish to use the name here as I used a number)
3.) Create a cross table with Month along your horizontal (Top) Year on the Vertical (left) and your count/amount as the body.