As a reminder, here is the sample data defining what the AdventureWorks report output should look like: here is a query written to meet the same requirements, but without the SUM...OVER construction used last time: 1: SELECT INV.Bin, 2: INV.Quantity, 3: INV.ProductID, 4: INV.Quantity, 5: SubAgg.total_in_bin 6: FROM Production.ProductInventory INV