Hello all. I have inventory data that includes some columns like this:
I want to produce a pivot table showing the quantity of each type of item on hand at the end of each month.
column: monthend of each month
measure: quantity in stock (i.e. sum quantity if the item was received before the column's monthend and was either never sent or was sent after that column's monthend)
I hope that makes some sense... any help appreciated.