cancel
Showing results for 
Search instead for 
Did you mean: 

Monthly prices increases in crosstab

Former Member
0 Kudos

Hello all,

I am currently developing a DESKI report that will tell me in which month a supplier has put through a price increase and what the value of the price increase is (%), by product reference (SKU).

The data provider pulls in the following fields from the universe:

- suppliername

- SKU

- SKU description

- Period (format is yyyymm)

- purchase price

I have also put prompt conditions on suppliername and on Period to run the report on specific suppliers and timeframes.

I have been trying to do this in a crosstab, with the Period running across the top.

For the price increase I need a formula that calculates this:

(Price (current month) / Price (previous month)) -1

This doesn't work in a crosstab however, because I can't create a formula that 'looks up' the price of the previous month

Any ideas?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Alain,

I think the formula should look like

=(<price> - Previous(<price>)) / Previous(<price>)

Cheers,

Harry

Former Member
0 Kudos

Hi Harry,

Thanks for the reply.

I didn't know there was a Previous() function. I will try that and let you know if it worked.

Alain

Former Member
0 Kudos

Hello Harry,

That has worked very well, thanks for the help.

I will know to use the Previous() function for similar things from now on.

Regards,

Alain

Answers (0)