I finally got back to this report.. this will work, thanks for the help folks.

Good call on the view, I think I was staring at it way too long

Thanks again for all the help. That put me...

Thanks for the quick response Noel!

Although the OrderedUnits columns are in the other source table "OrderDetailSize", adding that seems to throw it into a loop. And you are correct...