Combo Chart - Full Accumulation Limits

[ZoeM]

Hello Community.

I have a glidepath combo chart which shows Planned vs. Delivered product for the year.

I am trying to create limits for both metrics such that the planned line should start in the current month, April in this case, and still be the accumulated amount of planned (Jan through Apr).

The Delivered bars should stop at current month, Apr in this case and not show remaining. 

Please see attached application. 

Is this possible?

Thanks for the help.

[ZoeM]

I figured it out. I had to change the formula to MonthStart() instead of Month()...

Thanks guys for all your help!