Hi, I have a report that shows me the number of sales that each of my reps sold every day. (My querry did the math for me.... i.e. in the Total row, I have three different fields. SALESREP, SALESDATE and ID.. I "grouped" the SALESREP field and the SALESDATE field and I choose "Count" on the ID field. viola... it counts them per day)
So it looks like this... (WITH A "between /and" Date Range)...
10 John Smith 7-29-09
4 John Smith 7-29-09
6 John Smith 7-30-09
7 John Smith 7-31-09
5 Sue Jones 7-29-09
6 Sue Jones 7-29-09
3 Sue Jones 7-30-09
12 Sue Jones 7-31-09
How do I add the total sales for each SALESREP?
I tried running an expression in all different areas of a report... =sum([CountofID]) but I get errors.