cancel
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

6

8
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)

amitrathi239
Active Contributor
0 Kudos

Hi,

Have you tried with Previous function in the webi table.

=Previous([Quantity])

Amit

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.