Inventory - Non Cumulative

Hi

I have inventory data coming from legacy syste.

I have the following fields.

Date Mtrl Qty.

As this is coming daily and i would like to keep the history in the ODS as well as cube. How can i make Qty as non cumulative with out Inflow / Out flow.

I should be looking at the reports based on wk, month and qtr.