Runniing Values in Charts

I have a table which show the sales year to date by week. The sales amount is
a running value and it will keep incrementing as the weeks progress.
If i use the same value for the chart it does not allow RunningValue for
scope Nothing. How do i do the equalant in a chart to xhow the cumulative by
week rather than just the week figures. ex:
Actual Cumulative
Week1 1000 1000
Week2 1500 2500
Week3 1000 3500
First column is
Sum(cdec( Fields!CURRENTANNUALPREMIUM.Value ))
second is
RunningValue(cdec( Fields!CURRENTANNUALPREMIUM.Value ), SUM, Nothing)
this works fine on table but not in chart. Please help me do cumulative charts
regards
GaneshSorry, RunningValue() in charts is not supported on RS 2000. It is supported
on RS 2005 though.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ganesh" <Ganesh@.discussions.microsoft.com> wrote in message
news:25E16A7D-A53D-4DFE-BD5E-4036A3C56EBD@.microsoft.com...
>I have a table which show the sales year to date by week. The sales amount
>is
> a running value and it will keep incrementing as the weeks progress.
> If i use the same value for the chart it does not allow RunningValue for
> scope Nothing. How do i do the equalant in a chart to xhow the cumulative
> by
> week rather than just the week figures. ex:
> Actual Cumulative
> Week1 1000 1000
> Week2 1500 2500
> Week3 1000 3500
> First column is
> Sum(cdec( Fields!CURRENTANNUALPREMIUM.Value ))
> second is
> RunningValue(cdec( Fields!CURRENTANNUALPREMIUM.Value ), SUM, Nothing)
> this works fine on table but not in chart. Please help me do cumulative
> charts
> regards
> Ganesh