Displaying Current Day, WTD and MTD Totals

[MonkeyBrains]

I have a report that I want to build based on sales production by branch. The group by will be the Branch with details below for each sales rep. Basically I want a report that will list each sales rep and the current day sales along with Week to Date and Month to Date sales. The totals will just be a count of the # of items...might expand to include $ amount later.

Someone told me to do SQL Expressions, which I have investigated. My only problem with these is that I do not know how to get it to count for each individual sales rep, instead they count as a whole.

I get hung up since I am doing 3 levels of aggregation but want to display the numbers all side by side.

Any help would be greatly appreciated.