How to add Total to Matrx Column/Row

Hi there,
I have a report with 2 column groupings and 5 row groupings looks like
this:
+Unit
+Time
+Type +Sub_Type +Start +Result +Orig SUM(!Field1.Value)
I want to add "Total" to every column and every row and final total
like this:
+Unit
+Time
+Type +Sub_Type +Start +Result +Orig SUM(!Fieldxx) Total_of_Row
Total_of_Column Total
How can I add a column at the right end and a row at the bottom? What
kind of expression should I use?
Thanks a lot.
HenryHenry,
I'm not sure how far along you are but I found out how to add Row & column
subtotals by accident. In Layout mode, right click your "Row" or "Coumn"
field and select SubTotal. THe problem I am experiencing is you have very
limited control over the style. ie wanting the subtotals to be bolded.
Hope this helps - Glen
"Henry" wrote:
> Hi there,
> I have a report with 2 column groupings and 5 row groupings looks like
> this:
> +Unit
> +Time
> +Type +Sub_Type +Start +Result +Orig SUM(!Field1.Value)
> I want to add "Total" to every column and every row and final total
> like this:
> +Unit
> +Time
> +Type +Sub_Type +Start +Result +Orig SUM(!Fieldxx) Total_of_Row
> Total_of_Column Total
> How can I add a column at the right end and a row at the bottom? What
> kind of expression should I use?
> Thanks a lot.
> Henry
>|||It works well, Thanks a lot.
Henry
"Glen" <Glen@.discussions.microsoft.com> wrote in message news:<27B4E130-0C08-49DA-82B2-8E94B66B0216@.microsoft.com>...
> Henry,
> I'm not sure how far along you are but I found out how to add Row & column
> subtotals by accident. In Layout mode, right click your "Row" or "Coumn"
> field and select SubTotal. THe problem I am experiencing is you have very
> limited control over the style. ie wanting the subtotals to be bolded.
> Hope this helps - Glen
> "Henry" wrote:
> > Hi there,
> >
> > I have a report with 2 column groupings and 5 row groupings looks like
> > this:
> >
> > +Unit
> > +Time
> > +Type +Sub_Type +Start +Result +Orig SUM(!Field1.Value)
> >
> > I want to add "Total" to every column and every row and final total
> > like this:
> >
> > +Unit
> > +Time
> > +Type +Sub_Type +Start +Result +Orig SUM(!Fieldxx) Total_of_Row
> > Total_of_Column Total
> >
> > How can I add a column at the right end and a row at the bottom? What
> > kind of expression should I use?
> > Thanks a lot.
> >
> > Henry
> >