Adding Column AVGs on Matrix Reports

Hi,
Does anyone know how to add an AVG of a column in a matrix report? Its
obvious how to do a subtotal but I can't figure out how to add an
aggregate AVG for all columns. I also need to have the AVG below the
Column headers not at the bottom of the report as usual (see sample
below).
Column1 Column2 Column3
-- -- -- --
AVG 1.67 1.34 2
Row1 2 3 1
Row2 3 1 1
Row3 0 0 4
Any response is much appreciated.
Thanks,
ClaudeYou could write a simple expression like
=Sum(fields!Detail.Value)/Count(fields!Detail.Value) where detail is the
field pointing to 2,3...etc. instead of using subtotal. Insert a static row
at the top and use this expression. You could use tables instead of matrix (I
find it much cleaner than matrix specially when you dont have column
groupings and can do with row groupings)
"Claude" wrote:
> Hi,
> Does anyone know how to add an AVG of a column in a matrix report? Its
> obvious how to do a subtotal but I can't figure out how to add an
> aggregate AVG for all columns. I also need to have the AVG below the
> Column headers not at the bottom of the report as usual (see sample
> below).
> Column1 Column2 Column3
> -- -- -- --
> AVG 1.67 1.34 2
> Row1 2 3 1
> Row2 3 1 1
> Row3 0 0 4
> Any response is much appreciated.
> Thanks,
> Claude
>