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

adding a field

What's the SQL for adding a field to a table? And can you direct me to the
documentation. Is it an ALTER TABLE?you got it
alter table is it.
google alter table
"Les Stockton" <LesStockton@.discussions.microsoft.com> wrote in message
news:A45A259E-D86C-4B19-B923-A39BFCE0255E@.microsoft.com...
> What's the SQL for adding a field to a table? And can you direct me to
> the
> documentation. Is it an ALTER TABLE?|||Alter table add <columnname> <datatype>
"Les Stockton" <LesStockton@.discussions.microsoft.com> wrote in message
news:A45A259E-D86C-4B19-B923-A39BFCE0255E@.microsoft.com...
> What's the SQL for adding a field to a table? And can you direct me to
> the
> documentation. Is it an ALTER TABLE?|||Yes it's the ALTER TABLE statement.
If you look in BOL it's under ALTER TABLE, but the code is :
ALTER TABLE doc_exa ADD column_b VARCHAR(20) NULL
Adam J Warne, MCDBA
"Les Stockton" wrote:

> What's the SQL for adding a field to a table? And can you direct me to th
e
> documentation. Is it an ALTER TABLE?|||Yes, it's:
ALTER TABLE table_name ADD col_name col_type col_nullability;
For example,
ALTER TABLE T1 ADD col1 INT NOT NULL DEFAULT(0);
SQL Server's Books Online has info about this under ALTER TABLE.
BG, SQL Server MVP
www.SolidQualityLearning.com
"Les Stockton" <LesStockton@.discussions.microsoft.com> wrote in message
news:A45A259E-D86C-4B19-B923-A39BFCE0255E@.microsoft.com...
> What's the SQL for adding a field to a table? And can you direct me to
> the
> documentation. Is it an ALTER TABLE?