on 08-25-2015 8:42 AM
Hi everyone.
I have a table where I need to show sale quantities from the previous year in the current year column.
More exactly my desired table shown below.
Actual | Desired result | |||||||
Item Id | 2013 | 2014 | 2015 | Item Id | 2013 | 2014 | 2015 | |
517552B010 | 6 | 8 | 9 | 517552B010 | 6 | 8 | ||
545843J000 | 10 | 12 | 15 | 545843J000 | 10 | 12 | ||
281132P300 | 22 | 35 | 46 | 281132P300 | 22 | 35 | ||
291103V100 | 9 | 15 | 17 | 291103V100 | 9 | 15 | ||
1884108051 | 6 | 8 | 7 | 1884108051 | 6 | 8 |
I have used previous year filter on query base before.
But in this case I don't have any prompts in my report.
I just need to create variable in order to define previous year, like ([Sale_date]-1)
is it possible? or is there any way to solve this problem?
thanks all in advance
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Have a look at RelativeValue functionality. It'll be easier for you to read through the worked example in the help than me to try and fit it to your situation
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.