Column Totals

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,
DCIf 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
>|||thank you for this as well.
tango
"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
> >
> >
>
>