we have a chart in Excel that shows the cumulated values of reached milestones (thick lines). Additionally we have a line that shows the cumulated planned milestones in the next weeks (dashed line). The reached milestones stop at the current week while the plan values are shown for the following 15 weeks.
I created the same chart in Board and set Yearly Moving Total to my two cubes (reached and planned milestones). Board shows both cubes for the complete time range. Is it possible to stop accumulation of the reached milestones at the current week (so reached milestones are only shown in the past) and planned milestones are accumulated and shown in the future?
Thanks in advance.