changing subtotal expression

Hello,

I'm using a matrix report to display scores for certain items on certain criteria.
The items are on the left and the criteria at the top.

Now I would like to have some sort of subtotal row at the end of each group of items that displays the average value of all the scores for that group and not simply adds up the scores.
The built-in subtotal just adds up the scores, where I want the average value to be displayed.

Isn't there an easy way to change the subtotal expression and make it calculate the average value instead of the sum?

Thank you for your time,

Kenny

Yes this can be done through the InScope function. Please read this related thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=276213&SiteID=1

-- Robert