Reporting Services rolling sub-total in report

Any ideas on how to add a rolling sub-total within a group of rows? Essentially I want a report to show the sum of one field up to that row.
From http://www.developmentnow.com/g/115_2005_1_0_20_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comJohn,
Try the runningvalue function in SSRS. The 3 parameters for the
function are expression, aggregate function, and scope. You ought to be
able to use this to create a running sum column, either for the report
or within your groups.
-Josh
John Marcus wrote:
> Any ideas on how to add a rolling sub-total within a group of rows? Essentially I want a report to show the sum of one field up to that row.
>
> From http://www.developmentnow.com/g/115_2005_1_0_20_0/sql-server-reporting-services.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.comsql

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
> > >
> > >