Skip to main content
Question

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!
      This topic has been closed for replies.

      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.


      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.
      Darn, thank you both for your input.
      Terms & ConditionsAccessibility statement