I need to create a report from a dimensional data source that will show the sales by weekday and date for the current month and last years current month. I've attached a screenshot of the desired outcome. This report will run daily. I've tried creating two separate queries and UNION the two but the data either repeats itself in my list report for LY Current Month or I get an incompatible data type error.
Any advice would be appreciated.