"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