on 09-10-2015 8:32 PM
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 date | year sales |
---|---|
02Jan 2015 | 200 |
03 Jan 2015 | 100 |
04Jan 2015 | 100 |
Last year table from query2
year date | year Sales | relative date |
---|---|---|
01Jan2014 | 130 | 02Jan2015 |
02Jan2014 | 100 | 03Jan2015 |
03Jan2014 | 120 | 04Jan2015 |
Expected output
Year date | Current year sales | Last year sales |
---|---|---|
02Jan2015 | 200 | 130 |
03Jan2015 | 100 | 100 |
04Jan2015 | 100 | 120 |
I tried to merge year date from query1 to relative date fromquery2, but merge is greyed out.
Any input would be appreciated
Thanks
Ben
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.