This solution apparently does not quite work.

When sum against the fact_product purchase cost is executed, it is executed against the entire product cost table. In other words, the result is always the total cost of all products.

This is not correct, the cost that should be returned would be the cost of products that appear in the revenue set, which is a subset of all products, because not all products generate revenue in every period.