I previously tried the average & it works great for the subgrouping headers.  The problem that I'm running into with that is with the main grouping header - value for that is incorrect for what I need.  It's the opposite in this scenario - the main group heading is off & the subgroup header is corre...

I have a report where I am calculating average users' average hours per week.  In my grouping header, I want to show the sum average of the hours over a 6 week period (so total hours over the 6 week period divided by 6) & then in the subgroup headers (each row) I want show the average hours per week...