Total Average From Summary Reports

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
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!
Photo of Bullseye

Bullseye

  • 516 Points 500 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
you should be able to define the column in your summary report as average instead of total.
On a Summary report when you choose which field(s) are to be be Summarized you can choose to Summarize by "Averages" instead of by "Totals"  if you like you can summarize the same field twice on the report, once each way.
Photo of Bullseye

Bullseye

  • 516 Points 500 badge 2x thumb


Yes, I did see that.  Unfortunately, I would like the weekly listings to be total, and only the final row to be averaged.
Can't do that natively.
Photo of Bullseye

Bullseye

  • 516 Points 500 badge 2x thumb
Darn, thank you both for your input.