Hi Smitty,
a chart is very similar to a matrix. A chart series grouping is equivalent
to a matrix row grouping. What you want in a chart RunningValue is that it
resets on series / rows (rather than on categories / columns - because this
is what you have right now).
RunningValues inside a matrix or a chart cannot use the Nothing scope or a
dataset scope right now. They must use a grouping scope inside the chart.
There are two cases:
(1) the chart does not have any chart data series grouping at all:
Add a new "fake" series grouping, i.e. based on a constant group expression
value, e.g. =1. On the "fake" series grouping, set the grouping label
expression to ="" (i.e. empty string), so that the legend does not show the
fake group. Use the name of this "fake" series grouping for the scope name
of the RunningValue.
(2) the chart already has one or more existing data series groupings:
Follow all the steps described under (1) above. Then apply the following
additional steps:
The "fake" group must be the outermost series group if other groups are
present - i.e. in the chart properties dialog / data tab, the fake group has
to be on the top of the list of series groups (use the arrows to change the
order of groups in the list).
Hope this helps,
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
[quoted text, click to view] "Smittoid" <Smittoid@discussions.microsoft.com> wrote in message
news:11ADA552-C14D-403E-8538-56178B8836AE@microsoft.com...
>I am working on a straightforward table and chart to present a graph of
> cumulative revenue.
>
>
>
> My data set returns revenue per month, and I'd like to display a chart
> that
> shows the month by month sum of revenue.
>
>
>
> In my table I use the following to create a column with the appropriate
> values:
>
>
>
> =RunningValue(Fields!Actual_Revenue.Value, Sum, "table1")
>
>
>
> In my chart, I have a category group for the "months" and a Value set for
> "Cumulative Revenue" with the following formula:
>
>
>
> =RunningValue(Fields!Actual_Revenue.Value, Sum, "chart1_month")
>
>
>
> This returns a chart that is exactly the same as the "actual_revenue" -
> i.e.
> no running sum. Logically, I'd assume I should expand the scope beyond the
> "month", however I get errors whenever I try to use just "chart1" or
> Nothing
> as the scope.
>
>
>
> Any thoughts?
>
>
>
> Smitty
>
