Thanks, this is a good start that I can work from. As I stated earlier, there are an enormous amount of orders for each calendar year, and it would be easier if it were simply a calendar month, but because it has to be a "31 day" period, there could possibly be overlapping orders that equal to =>50% of AADQ for any given part number, this is what I have been finding doing it manually. But I like this table, it will most likely be sufficient for what I need, I just need to look at it deeper and make sure I can present it this way. They really like pivot tables too, so that's a plus. Thanks again.