Cumulative Total not effected by slicer

Hi there

Sorry for the delay! 

The picture is below is the graph that gets produced by the data above. Essentailly it is an inventory movement table that i have exported from Nav Dymamics.  I can get an inventory on a set date by working a slicer back wards and the cumultaive calc stops at the slicer date. But if i narrow the date from the start date the movements prior are ignored and the invenotry is wrong. 

Essentilaly the output required is a table that has the inevntory on each day for each item.  

A link of sample data is below

https://1drv.ms/u/s!AoFC8Tq7aHhrtGwA_t8hpYC4SU-P?e=2QL3mJ