"DC" <DC@yahoo.com> wrote in message
news:OrGA2xClEHA.2140@TK2MSFTNGP15.phx.gbl...
>
>
> Hi,
>
> I am trying to come up with column totals like,
>
> Jan Feb Mar ...
> P1 2000 2 5 6
> 2001 7 10 8
> 2003 10 5 9
> P1 2000 4 12 10
> 2001 7 10 8
> 2003 10 5 9
> TOTAL 40 47 50
>
> How can I do that? I know it is related to the scope of sum function, but
I
> couldn't figure out.
>
> Thanks a lot.
>
> Regards,
> DC
>
>

"Robert Bruckner [MSFT]" wrote:

> If this is a matrix, then just add a subtotal row (BOL has more information
> on subtotals).
>
> If it is a table, then add a group footer or a table footer. Then you just
> need to drop the field into the according drop zone. The scope of the sum is
> automatically determined as the "current" scope which would be the entire
> table if the sum is in the table footer.
>
> Alternatively, you can always explicitly specify a scope. Assuming a table
> is named "Table1", an expression of =Sum(Fields!Sales.Value, "Table1")
> anywhere within the table would evaluate to the total sales of the table's
> data.
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
>
> "DC" <DC@yahoo.com> wrote in message
> news:OrGA2xClEHA.2140@TK2MSFTNGP15.phx.gbl...
> >
> >
> > Hi,
> >
> > I am trying to come up with column totals like,
> >
> > Jan Feb Mar ...
> > P1 2000 2 5 6
> > 2001 7 10 8
> > 2003 10 5 9
> > P1 2000 4 12 10
> > 2001 7 10 8
> > 2003 10 5 9
> > TOTAL 40 47 50
> >
> > How can I do that? I know it is related to the scope of sum function, but
> I
> > couldn't figure out.
> >
> > Thanks a lot.
> >
> > Regards,
> > DC
> >
> >
>
>