Convert YTD Sale to MTD Sale to display in line Chart

[priyanka08]

Hi  Everyone,

We have received the  YTD Sales  every  month with only one date on that particular month.Which means for Feb-21 include sales from Jan-21 to Feb-21 but include date of Feb -21 only.Similarly for March 21 include data from Jan-21 to Mar-21  but include date of Mar -21 only

My requirement is display Line Chart  represent MTD Sales  for each month

Refer the attached copy of Sample data

for example

For SalesReport_31012022. This is ytd sale for Jan-21  with can work as MTD

For SalesReport_28022022- This include YTD sales for Feb -21 means  if we consider first 1120 ytd sale is actually sales  from Jan- 21 to feb -21 & MTD Sales for Feb -21 is 1120-100= 1020

for SalesReport_31032022

 This include YTD sales for Mar -21 means  if we consider first 1220 ytd sale is actually sales  from Jan- 21 to feb -21 & MTD Sales for Feb -21 is 1420-1120-100= 200

[priyanka08]

Added fresh sample data