Compare sales of today (dd/mm/yyy) with sales of same day last year
Hope you can help me!
I need to build a chart with the sales info of this year (column) day per day (rows) and the sales info of this day but last year (column). I mean, don´t have to compare with the exact date, but with the date that this weekday last year was.
In my database, among other data, I have a column with all the dates day per day of this year and last year (dd/mm/yyy) and another column with their respective sales per day.