hello there guys,

i been working on this file from last two weeks to get my desired results of the stock shortages or access to link them back to my main inventory file, i some how managed to get the report in pivot table, my question now is how to calculate the difference as it is not part of my actual data set, and other how to link that difference back to respective item in the data set so i can link it to my actual inventory file.

thanks in advance

Usman