Skip to Content
0
Former Member
Aug 25, 2015 at 07:42 AM

Sale amount from the previous year

25 Views

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