cancel
Showing results for 
Search instead for 
Did you mean: 

Combine current year and last year sales by date

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Ben, you can only merge dimmensions from objects that came fron the queries, not variables.

Why don't you try creating year date of second query, like

1 [relative date] = FormatDate([year datr query 1];" dd/MM")+(Year([year d

1ate query 1])-1)

2 merve both queries on [year datr]

3 create a variable [last year sales] =([year sales] where ([year date]=[relative date]))

4 bring [year date], [year sales] and [last year sales],

Cheers