0 Replies Latest reply: Dec 9, 2017 11:31 AM by Thomas Pike RSS

    Pivot table showing quantity of each item type on hand at end of each month

    Thomas Pike

      Hello all. I have inventory data that includes some columns like this:

       

      idtypequantityreceived_onsent_on
      1A221-1-201715-2-2017
      2B321-1-201720-3-2017
      3B221-1-2017
      4C121-1-201713-11-2017
      5D321-1-2017

       

      I want to produce a pivot table showing the quantity of each type of item on hand at the end of each month.

      row: type

      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.