• Still ultimately the same idea, except that you'd cross join your product table with the Tally table (which fills in each product by month in the same way as I did with flat variables.)

    Once you have all of the cells represented - it simply becomes a PIVOT operation.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?