Matrix Totals Problem - SSRS 2005

I wasn't able to get my totals working accurately in a table footer using SUM, so I though hmm, maybe try matrix...well, still same type of problems...a bit different but still, my totals are not totalling the columns!

Screen Shot:

http://www.photopizzaz.biz/matrix_totals_problem.jpg

I don't know what else to do, I give up at this point and need help from someone here who has already gone through these headaches!

I don't understand why BOL doesn't address more complicated issues such as this...they barely tell you anything there.

I believe you need to preface your column expressions with sum: ie: the expression under customer number would be: sum(fields!customernumber.Value)sql

Matrix report (double row footer)

I have data that I would like to pivot in a matrix style report. The problem
is that I need two lines in my footer section and I am unable to find a way
to "insert" an additional row into my footer and use a calculated field to
calc the avg below the totals.
Year Month Group A Group B
1999 Jan 10 20
1999 Feb 10 20
.
.
Annual Total 20 40 Footer Line 1
Monthly Avg 10 20 Footer Line 2
Is there a way to do this?I have the exact same query. Anybody out there able to help.
"skmonroe" wrote:
> I have data that I would like to pivot in a matrix style report. The problem
> is that I need two lines in my footer section and I am unable to find a way
> to "insert" an additional row into my footer and use a calculated field to
> calc the avg below the totals.
> Year Month Group A Group B
> 1999 Jan 10 20
> 1999 Feb 10 20
> .
> .
> Annual Total 20 40 Footer Line 1
> Monthly Avg 10 20 Footer Line 2
> Is there a way to do this?