Running totals in matrix?

Is it possible to create a row in a matrix that represents the running total
over time? Can I do this in the matrix itself or does this need to be
calculated in the dataset? If it's the latter, any ideas for how to do this
simply?
Example:
Jan Feb Mar
Monthly Sales 150 59 124
Cumulative Sales 150 209 333
Thanks!there is a running value in the aggregation expression...
On Jan 5, 1:36=A0am, jmann <jm...@.discussions.microsoft.com> wrote:
> Is it possible to create a row in a matrix that represents the running tot=al
> over time? =A0Can I do this in the matrix itself or does this need to be
> calculated in the dataset? =A0If it's the latter, any ideas for how to do =this
> simply?
> Example:
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Jan =A0= =A0 =A0 Feb =A0 =A0 =A0 Mar
> Monthly Sales =A0 =A0 =A0 =A0 =A0 150 =A0 =A0 =A0 =A059 =A0 =A0 =A0 =A0 ==A0124
> Cumulative Sales =A0 =A0 =A0150 =A0 =A0 =A0 =A0209 =A0 =A0 =A0 =A0333
> Thanks!|||On Jan 5, 4:53 am, Sridar K <srid...@.gmail.com> wrote:
> there is a running value in the aggregation expression...
> On Jan 5, 1:36 am, jmann <jm...@.discussions.microsoft.com> wrote:
> > Is it possible to create a row in a matrix that represents the running total
> > over time? Can I do this in the matrix itself or does this need to be
> > calculated in the dataset? If it's the latter, any ideas for how to do this
> > simply?
> > Example:
> > Jan Feb Mar
> > Monthly Sales 150 59 124
> > Cumulative Sales 150 209 333
> > Thanks!
The Running Total/Value expression is explained here:
http://msdn2.microsoft.com/en-us/library/aa255824.aspx
Just as an FYI, you would normally use a cursor or while loop to
provide this type of functionality in the stored procedure/query that
is sourcing the report. Of course, this option adds complexity and
poor performance, so I would suggest using the Running Value
expression. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||I'm trying the RunningTotal expression (Fields!Sales.Value, Sum, Nothing) and
getting the following error:
"The value expression for the textbox â'textbox6â' has a scope parameter that
is not valid for RunningValue, RowNumber or Previous. The scope parameter
must be set to a string constant that is equal to the name of a containing
group within the matrix â'matrix1â'." Not sure what this means. Any ideas?
Thanks!
"EMartinez" wrote:
> On Jan 5, 4:53 am, Sridar K <srid...@.gmail.com> wrote:
> > there is a running value in the aggregation expression...
> >
> > On Jan 5, 1:36 am, jmann <jm...@.discussions.microsoft.com> wrote:
> >
> > > Is it possible to create a row in a matrix that represents the running total
> > > over time? Can I do this in the matrix itself or does this need to be
> > > calculated in the dataset? If it's the latter, any ideas for how to do this
> > > simply?
> >
> > > Example:
> >
> > > Jan Feb Mar
> > > Monthly Sales 150 59 124
> > > Cumulative Sales 150 209 333
> >
> > > Thanks!
>
> The Running Total/Value expression is explained here:
> http://msdn2.microsoft.com/en-us/library/aa255824.aspx
> Just as an FYI, you would normally use a cursor or while loop to
> provide this type of functionality in the stored procedure/query that
> is sourcing the report. Of course, this option adds complexity and
> poor performance, so I would suggest using the Running Value
> expression. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>