Hello! Could you please help me solve this problem?

On the Zoho Analytics chart, I need to display two metrics: cumulative sales of the current year and cumulative sales of the previous year. In the current year, there may be some weeks with no sales, meaning there are no values (and no incremental). In this case, the chart should display the last value without any increase till the current date.

Currently, if I select "show missing values," the chart for the current year extends the line until the end of the year. However, I need it to show only up to the current week. How can I solve this issue?