3 months average of historical sales the year before
I need to calculate the three months average based on the historical sales data the year before.
For ex: Jan 20 Feb 20 Mar 20 - Average values should go under Jan 21.
100,0,100 - 66.7 Jan 21 value
Please could you suggest the optimal solution for the same? I have attached the screenshots for reference