Creating SUBTOTALS on a Matrix report

Hello
I have a matrix report and I'm trying to create a subtotal at the end of both the colum and the row field, so something like:
Jan Feb April Total
----
Beer =A31.00 =A32.00 =A32.00 =A35.00
Wine =A35.00 =A35.00 =A35.00 =A35.00
Spirits =A35.00 =A35.00 =A310.00 =A320.00
TOTAL =A311.00 =A312.00 =A317.00 =A370.00
So I need the two totals on the row and column sections, then i need a final total of both row and column totals in the bottom right hand cell. (exactly how a pivot report works in excel).
I have tried right clicking the matrix report and selecting Subtotal but this just gives me an empty cell when I preview the report. BOL says it's supposed to total up the values but it isn't doing this. Am I missing something? Any help would be very much appreciated!
Thanks in advance
janoIn the matrix cells you should always use aggregate functions (e.g.
=Sum(Fields!Sales.Value)). The same aggregate function will be applied to
the subtotals and the sums should automatically show up.
Did you look into the sample reports that come with the RS installation?
Some of them contain matrix examples - just compare them with your report.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jano" <janobermudes@.microsoft.com> wrote in message
news:28e5c01c464ea$9c46d870$a501280a@.phx.gbl...
Hello
I have a matrix report and I'm trying to create a subtotal
at the end of both the colum and the row field, so
something like:
Jan Feb April Total
----
Beer £1.00 £2.00 £2.00 £5.00
Wine £5.00 £5.00 £5.00 £5.00
Spirits £5.00 £5.00 £10.00 £20.00
TOTAL £11.00 £12.00 £17.00 £70.00
So I need the two totals on the row and column sections,
then i need a final total of both row and column totals in
the bottom right hand cell. (exactly how a pivot report
works in excel).
I have tried right clicking the matrix report and
selecting Subtotal but this just gives me an empty cell
when I preview the report. BOL says it's supposed to total
up the values but it isn't doing this. Am I missing
something? Any help would be very much appreciated!
Thanks in advance
jano