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?
Something like below
![Img3.JPG Img3.JPG](https://community.qlik.com/t5/image/serverpage/image-id/16573i64F2FD76299C00B4/image-size/large?v=v2&px=999)
Appreciate any help here!
Thank You!