I have a monthly dataset for different years (say 2017 and 2018) and I am trying t create a chart which would show the Rolling12 number at each month of 2018.
Month
Year
Amount
Jan
2017
400
Feb
2017
200
Mar
2017
300
Apr
2017
100
May
2017
500
Jun
2017
200
Jul
2017
500
Aug
2017
300
Sep
2017
300
Oct
2017
400
Nov
2017
100
Dec
2017
100
Jan
2018
500
Feb
2018
200
Mar
2018
200
Apr
2018
400
May
2018
400
Jun
2018
300
Jul
2018
100
Aug
2018
500
Sep
2018
500
Oct
2018
200
Nov
2018
100
Dec
2018
100
I want to create a graph for just 2018 months and show sum of amount for last 12 months against each month. How can I achieve this?