Showing results for 
Search instead for 
Did you mean: 

Sale amount from the previous year

Former Member
0 Kudos

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.

ActualDesired result
Item Id201320142015Item Id201320142015
517552B010  689517552B010


545843J000  101215545843J0001012
281132P300  223546281132P3002235
291103V100  91517291103V100915
1884108051  687188410805168

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

Accepted Solutions (1)

Accepted Solutions (1)

Active Contributor
0 Kudos


Have you tried with Previous function in the webi table.



Former Member
0 Kudos

Thank you very much Amit. I haven't tried that formula and it really helped.

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

I really appreciate your response Mark. Thanks to you I have learned one more useful function.