ON Hand Measure - need Qty in each Time bucket , not only in first.

Summary:

There is requirement to create a custom measure to show (on hand - total demand) across the planning horizon time bucket.
So if 1st week Demand is 100 and on hand is 500, then custom measure shows value 400
2nd week On hand is now 400 and demand suppose 100 , then custom measure should show value as 300

3rd week, on hand is now 300 , and demand suppose 120, then custom measure should show 300-120 = 180

4th week, on hand now 180, and demand suppose 200, then custom measure should show 180-200 = -20

same it should repeat for all time buckets.

On hand should keep on reducing based on total demand. and custom measure should show (on hand - demand) in each time bucket.