Adding a subtotal column to a matrix

Can anyone direct me on how to add a subtotal column to a matrix?
I have dates in each column header and I want to add another column that has
"Total" in its header and sums up the other columns.
ThanksRight-click on the column header and check the "Subtotal" option. In order
to access the subtotal formatting properties in the VS properties window,
you have to click on the little green triangle after you added the subtotal.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"M" <M@.discussions.microsoft.com> wrote in message
news:1B939293-22C6-4B2B-A1E9-F6C0548C314B@.microsoft.com...
> Can anyone direct me on how to add a subtotal column to a matrix?
> I have dates in each column header and I want to add another column that
has
> "Total" in its header and sums up the other columns.
> Thankssql

add MatrixRow for total and subtotal

Hi,
How could I add MAtrixRow for total and subtotal?
Or is any other way can do total and subtotal on Matrix?
I see the FoodmartSales.rdl of Reporting Service Example..
How could the Example add a MatrixRow for total and subtotal?
Thanks!
AngiIf you right click in a matrix row or column group cell you will find an
option to add a subtotal.
Note the green triangle in the upper right corner of the subtotal cell. If
you click this properties window will display the style properties for the
subtotal.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"angi" <angi@.microsoft.com> wrote in message
news:uX8%23Y4NZEHA.3432@.TK2MSFTNGP10.phx.gbl...
> Hi,
> How could I add MAtrixRow for total and subtotal?
> Or is any other way can do total and subtotal on Matrix?
> I see the FoodmartSales.rdl of Reporting Service Example..
> How could the Example add a MatrixRow for total and subtotal?
> Thanks!
> Angi
>|||Thanks!
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
:#1wfURSZEHA.3596@.tk2msftngp13.phx.gbl...
> If you right click in a matrix row or column group cell you will find an
> option to add a subtotal.
> Note the green triangle in the upper right corner of the subtotal cell. If
> you click this properties window will display the style properties for the
> subtotal.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "angi" <angi@.microsoft.com> wrote in message
> news:uX8%23Y4NZEHA.3432@.TK2MSFTNGP10.phx.gbl...
> > Hi,
> >
> > How could I add MAtrixRow for total and subtotal?
> > Or is any other way can do total and subtotal on Matrix?
> > I see the FoodmartSales.rdl of Reporting Service Example..
> > How could the Example add a MatrixRow for total and subtotal?
> >
> > Thanks!
> > Angi
> >
> >
>|||No. However this is on the feature wish list.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Laura" <Laura@.discussions.microsoft.com> wrote in message
news:026DFC5F-574E-462A-B41D-DAA671ED55D7@.microsoft.com...
> Hi Bruce,
> Is there a way to edit the expression on this Subtotal? Thanks.
> "angi" wrote:
> > Thanks!
> >
> > "Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
> > :#1wfURSZEHA.3596@.tk2msftngp13.phx.gbl...
> > > If you right click in a matrix row or column group cell you will find
an
> > > option to add a subtotal.
> > > Note the green triangle in the upper right corner of the subtotal
cell. If
> > > you click this properties window will display the style properties for
the
> > > subtotal.
> > >
> > > --
> > > Bruce Johnson [MSFT]
> > > Microsoft SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > >
> > > "angi" <angi@.microsoft.com> wrote in message
> > > news:uX8%23Y4NZEHA.3432@.TK2MSFTNGP10.phx.gbl...
> > > > Hi,
> > > >
> > > > How could I add MAtrixRow for total and subtotal?
> > > > Or is any other way can do total and subtotal on Matrix?
> > > > I see the FoodmartSales.rdl of Reporting Service Example..
> > > > How could the Example add a MatrixRow for total and subtotal?
> > > >
> > > > Thanks!
> > > > Angi
> > > >
> > > >
> > >
> > >
> >
> >
> >