How to export sales for each item per day in a month easily?
How to export sales for each item per day in a month easily?
I want to export every sales record I have because I want to use Lokad for sales forecasting. I want to know how many sales each item have per day in a month.
Example schema
Id Date Quantity
1 2013-07-01 174
1 2013-07-02 96
3 2013-07-03 271
2 2013-07-04 335
1 2013-07-06 72