I want to calculate max sales for each d
I want to calculate max sales for each day from last one year for every product.
e.g. suppose latest sales date is "YYYY-MM-DD":"2013-09-05" then maximum sales from period of one year "2013-09-05" to "2012-09-04".