I have a table with a column sales in my model.
I would like to calculate the average of the sales of the last 3 months but month to date.
for example:
If today is the 3rd of April I want the average of the sum of the sales until the 3rd day of the 3 previous months.
The same thing for the last 12 months.
Thank you!