past 12 months for every month

[Channa]

Hi All i have data like attach file

from 2017 to 2021 April

for 2021 April i need sum of (2021 April to 2020 March)

Date: first date of every month

can you please help me with this

[Channa]

 Thank you @fmvizciano

i just need to sum of sales by Right_date and extract Max Date from "Date" for each Right_date

2019-11-01 india prod1 989

[Channa]

HI ALL

i need to check

where Product= Product and Country=Country 

and the i need to calculated previous 12 months sales for each month