I want to create a MTD against target line chart but I'm not sure it is actually possible to do it the way I want - hoping I can be proven wrong.
Line 1: Accumulative Daily Target - e.g. solid red line
Line 2.1: Accumulative Daily MTD (up until last night) - e.g. solid blue line
Line 2.2: Accumulative Daily Forecast MTD (from today til end of month) - e.g. dotted blue line