I'm trying to find out the price differences by articles from our sales table.
The fields uses are
I need to show the difference concerning the price from the "current" order to the previous order. If an article is sold more often also only the last order vs. last order -1 is relevant. Has someone a hint for my how to implement this in loading script?
you can create a new tablebox (ordrid, aticleid, price). go to properties and sort descending ordid. make sure to make a selection on the last articlid somewhere on the sheet. you should see if there is a difference in the 2 first listed prices
I'm trying to show within the chart that article a1 was bought last time with price 13 last previous order was with price 12. the order on 1.9.2011 with price of 10 isn't relevant. Only the current and the prev order are relevant.
last order with price 13 (+1) or something like that.