I used OVER clause to add an extra checking column (which you don't have) to verify sum of allocated freight per order. If we remove this column, it will work similar way.

Ah, I see....I only have the verification at the end with the COMPUTE BY sum for testing. Thanks for clarifying. When I take out the OVER clause, the plans are the same. Thanks.