I am trying to derive Daily sales from daily MTD sales. I want to create a viz that has a running sum of the daily sales. I have been able to accomplish this by adding a column in my excel worksheet which calculates the daily sales as the difference from the current day MTD Sales and the previous day, but was wondering if this is possible without adding the column in excel. Notice, there may be days where the MTD Sales is not provided in the excel spreadsheet.
Here is the viz I am trying to accomplish without adding a daily sales column in excel.