Reporting Services Matrix

Hello
Can you add a grand total row to a matrix like a pivot table. Can you sum
up results from a column in a matrix? Maybe add a calculated field to a
matrix?Hi Randy,
Right click on the "Rows" cell of the matrix and select "Subtotal".
take care!
Michelle|||Thank you very much. This worked
"Michelle@.bwalk.com" wrote:
> Hi Randy,
> Right click on the "Rows" cell of the matrix and select "Subtotal".
> take care!
> Michelle
>|||Does anybody know how to create a calculated field in a Matrix using a
subtotal value from a matirx against another value? I have a subtotal that
is taking 2 results from a column on a matrix. I want to take the subtotal
and divide it by a value returned from the other two fileds resulted from the
column on the matrix. To get a percentage. For example:
Matrix
Held Calls Calls Total Calculated FieldIn Matrix
20 50 70 HeldCalls/Total "to get %
"Randy" wrote:
> Thank you very much. This worked
> "Michelle@.bwalk.com" wrote:
> > Hi Randy,
> >
> > Right click on the "Rows" cell of the matrix and select "Subtotal".
> >
> > take care!
> > Michelle
> >
> >|||I'm looking for a way to do this with RS as well. I haven't found a way.
I'm going to write a Stored Proc that produces these types of results and
I'll just presesnt them in a grid.
"Randy" wrote:
> Does anybody know how to create a calculated field in a Matrix using a
> subtotal value from a matirx against another value? I have a subtotal that
> is taking 2 results from a column on a matrix. I want to take the subtotal
> and divide it by a value returned from the other two fileds resulted from the
> column on the matrix. To get a percentage. For example:
> Matrix
> Held Calls Calls Total Calculated FieldIn Matrix
> 20 50 70 HeldCalls/Total "to get %
>
> "Randy" wrote:
> > Thank you very much. This worked
> >
> > "Michelle@.bwalk.com" wrote:
> >
> > > Hi Randy,
> > >
> > > Right click on the "Rows" cell of the matrix and select "Subtotal".
> > >
> > > take care!
> > > Michelle
> > >
> > >