This content has been marked as final. Show 4 replies
In the example attached, I would like to add a fourth column so their value will be the current Quantity minus the Quantity value from the first Purchase for the same Product.
For example for product A, Fx will be Qty - 10 which is the value from the first purchase:
productID dtPurchase Quantity Fx A 01/01/2000 10 0 A 01/02/2000 9 1 A 01/03/2000 8 2
I know that's very simple for you guys...hope can you help me.
Thanks in advance.