I'm working on a report to display Budget, Actual and Variance information and have a question regarding chart series. I've got the month as my category field and what I would like to do is show the Budget figures for the entire year but only show the Actual and Variance series from January thru the current month. Right now, since there are no actuals for future months, the Variance numbers are huge and are throwing the Y-axis scale out of whack. Is there any way to do this? Thanks in advance for all of your help!

You need to change your variance calculation to conditional calculation that checks date each row and compares that to first of the current month. Below is sample expression that I put together based on my dataset. This will show - for all future months including current month. iif(Fields!begin_date.Value >= DateSerial(Year(Now), Month(Now), 1), "-", sum(Fields!actuals.Value) - sum(Fields!Budget.Value) Replace begin_date to your date (I used first of the month to roll up my actual/budget data)

That worked perfectly! Thank you!!