I need to aggregate data in 90 days chunk. For example, I have following data.
Date Custorm Qty
1/5/05 1 7
3/31/05 1 9
5/10/05 1 10
I need to sum(qty) for chunk of 90 days. The chunks should be such that the first chunk starts on 1/5/05, and goes to 4/5/05 (1/5/05 + 90 Days).
My second chunk would start from 5/10/05 and go 90 days from there (something like 8/9/05) and so forth and so on.
How can I accompalish this?
Please let me know, you can either send me an e-mail at email@example.com or reply to this message.