MonkeyBrains
March 28th, 2005, 03:27 PM
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.
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.