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:
- 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 😔