I would like to set a search timeframe of 1 week and for each day report the subtotals of Items 1, 2 and 3 (the items are the same for each day but the Quantity changes). The output would reflect this as:
2013-11-01.....Item 1.....Quantity
2013-11-01.....Item 2.....Quantity
2013-11-01.....Item 3.....Quantity
2013-11-02.....Item 1.....Quantity
2013-11-02.....Item 2.....Quantity
2013-11-02.....Item 3.....Quantity
2013-11-03.....Item 1.....Quantity
2013-11-03.....Item 2.....Quantity
2013-11-03.....Item 3.....Quantity
etc.
I am able to isolate all of the field data but i am not sure how to structure the search to give the above output.
Any help would be greatly appreciated.
... View more