Report Running Total
Hi
I have a report with The following:
Fiscal_Year, Period, Amount_Base and Group.
I have a line graph that has a series with 4 values (4 lines). I need to have a running total for each group. THe graph is limited to one fiscal year with a parameter. The Amount_Base and Period are the axis values.
I have tried sever different entries in the RunningValue and nothing seems to work.
I keep getting an error stating the Y expression for the chart 'YTDConsolRev2' has a scope parameter that is not valid.
I tried this with the chart name and it returns data, but the values do not look right.
=RunningValue(Fields!AMOUNT_BASE.Value,sum,"YTDConsolRev2")
This results in a running total on the 4 groups togther. I need each goup to have it's own running total, by each series group. How do I specify the
variable?
Any helpo would be appreciated.
Thanks,
Trish
Trish Leppa
April 18th, 2011 4:12pm
Never mind I figured out my problem. I needed to use the series group name.
=RunningValue(Fields!AMOUNT_BASE.Value,
sum,"YTDConsolRev2_SeriesGroup")
Thanks,
Trish
Trish Leppa
Free Windows Admin Tool Kit Click here and download it now
April 19th, 2011 12:14pm