Monthly closing balance

[dohere]

Item Received sheet has following 4-fields Item Issued Sheet has following has following 4-field

1-Month 2-Date 3- Item Code 4- Received Qty 1-Month 2-Date 3- Item Code 4 -Issued Qty

Required Result in power pivot
--------------------------------------------------- J A N U A R Y ---------------------------------------------------------F E B U A R Y
(1) Item code Received Qty - Issued Qty = JANUARY Closing Balance (2)----- Received Qty - Issued Qty = Feburay Closing Balance
--------------------------------------------------FORMULA??

 

[dohere]

Item Received sheet has following 4-fields Item Issued Sheet has following has following 4-field

(1)-Month (2)-Date (3)- Item Code (4)- Received Qty================ (1)-Month (2)-Date (3)- Item Code (4) -Issued Qty

Required Result in power pivot
--------------------------------------------------- J A N U A R Y ---------------------------------------------------------F E B U A R Y
(1) Item code (2)Received Qty - Issued Qty = JANUARY Closing Balance (2)----- Received Qty - Issued Qty = Feburay Closing Balance
--------------------------------------------------FORMULA??
ITM-003434''''''''''''''40'''''''''''''''''''''''''20''''''''''''''''' Required result Qty 20----------------10--------------5----------= Required Qty(20+10-5=25)