Line chart - current minus previous month

[dia2021]

Hi Everyone,

I have created a line chart based on the cumulative FY dataset, which is working fine. The only problem is how I can show data for October in the attached screenshot.

The trendline is created based on the current minus previous month, but how can I display data for the first month. I need to show the first month's data the way it is without any calc. 

Here is the formula associated with this chart : sum ([sales]) - Above(Sum({<MonthYear>}sales)) * Avg(1)

Any suggestions?

Thank you!

[dia2021]

@Or  Thank you for the idea! I will check the numbers in the table and start a new thread. But thanks once again for suggesting ideas and sharing knowledge.