• Have you added a Row Group on Division? Just doing the Sum() on the detail row isn't going to add grouping. You need to explicitly add a group. Check out this article for how to work with grouping in SSRS.