Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Combine current year and last year sales by date

Hi,

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.

Ex,

I created 2 tables ,

Current year table from query 1

year dateyear sales
02Jan 2015200
03 Jan 2015100
04Jan 2015100

Last year table from query2

year dateyear Salesrelative date
01Jan201413002Jan2015
02Jan2014100

03Jan2015

03Jan201412004Jan2015

Expected output

Year dateCurrent year salesLast year sales
02Jan2015200130
03Jan2015100100
04Jan2015100120

I tried to merge year date from query1 to relative date fromquery2, but merge is greyed out.

Any input would be appreciated

Thanks

Ben

Not what you were looking for? View more on this topic or Ask a question