Combine current year and last year sales by date
We want to show sales as follows
Date current year sales last year sales
We have special calendar , where last year date will not be same as -365 days .Hence relative date doesn't work out.
I created 2 tables ,
Current year table from query 1
|year date||year sales|
|03 Jan 2015||100|
Last year table from query2
|year date||year Sales||relative date|
|Year date||Current year sales||Last year sales|
I tried to merge year date from query1 to relative date fromquery2, but merge is greyed out.
Any input would be appreciated