Hi All,
Attached is the workbook for reference. Note problem I am having has been replicated using dummy data for privacy reasons.
Basically, what I have done (see Dashboard1 and Sheet 2 and 3) is visually align the Profits from each day to the previous day, and display the Sales only for Dec 31 2019.
What I would like to do is do what I have done in Dashboard 1 (and Sheets 2/3) all in 1 sheet for visual appeal.
I have attempted to do this in sheet 1, but the issue is that I am unable to properly shift the profit of each day to correspond to the previous day.
I hope this all makes sense!
Also, on a side note but not super important, does anyone know how to get a single date calendar filter (see sheet 4)
Any help is appreciated!
Aidan
