Total Average From Summary Reports
Hello,
I am trying to use a summary report to list the total sales each of our sales reps wrote over the last 7 weeks, but instead of totaling their 8 week sales, I would like to average them.
Right now, the main body of the report works perfectly - the total for each rep by week comes up. The only thing I need to fix is the average for each rep over the previous 8 weeks.
I appreciate any help. Hoping for a simple solution or checkbox I'm missing. Thanks!
I am trying to use a summary report to list the total sales each of our sales reps wrote over the last 7 weeks, but instead of totaling their 8 week sales, I would like to average them.
Right now, the main body of the report works perfectly - the total for each rep by week comes up. The only thing I need to fix is the average for each rep over the previous 8 weeks.
I appreciate any help. Hoping for a simple solution or checkbox I'm missing. Thanks!
