how to sum the total sales of the previous 365 days in a chart where these values are reported per single day in order to see how the value changes every day?
(i.e. Today=Sales of the last 365 days, Yesterday=Sales of the last 366 days les Today, etc)