Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
the opening balance of the stock should reflect in the Stock on Hand