Cumulative calculation in a Pivot table for projecting the stock on Hand for 2 years based on Demand

[HarshaGuduru]

I have Inventory source file which has fields like material,Plant , quantity required/ received as measure along with sum other measures and fields as dimensions.

I need to calculate/ Project the Stcok on hand based on the Demand & supply values in the source file which are from the field ( Receipt/issue ind) and the projection is for 2 years of data ( daily, Monthly, weekly) in a pivot table for the measure Quantity reqd/received.

the Pivot table should have fields like material type, reciept/issue indicator, MRP element description as dimensions. and measure as quantity reqd/received

the projection should start from the Current day to two years.

attached the source file for your reference.

can any body please suggest me on the solution.

[formosasol]

Hi,
Do you have a field that shows opening Balance for the stock items some of the items will have a negative balance if you sum all the Received and Issued for a stock item.

Regards
Frank

[HarshaGuduru]

the opening balance of the stock should reflect in the Stock on Hand