I have a question about dimensions that change. The fact is that when an order is received it is placed in the order table. When this order is finally sold (turnover), the amount in the order table goes to 0 and in the sales table to the order quantity. The number + amount therefore jumps from order.table to turnover.table.
However, this means that I can not see what was in the order table last year because it is now in the revenue table. Does anyone have any idea how I can store it so that I can still find out?