Skip to Content
0
Former Member
Nov 07, 2008 at 11:08 AM

Monthly prices increases in crosstab

11 Views

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?