Here is the result set I want to get (from old report): Customer parameter is set to select all, in case anyone had questions about that field.
.....
As you can see, the report works so that each customer is grouped under a given salesperson and a total tally is at the bottom.
My problem is that this is the result I keep getting when trying to replicate this result in my new report (values aside, I know I can clean those up in the properties):
How do I do the grouping so that my subtotals, per customer, are reflected in a grand total at the bottom (in yellow)? I can do this easily in SQL, but getting it to work in report builder is what's driving me nuts lol