Creating a products gap table with a Pivot Table and calculated fields or itms

[tanababa]

Hi,
Please see the link below. I have a table that I need to make a balance of inventory.
I would like to know how to do it with a pivot table ( I did it with sumifs )
http://sdrv.ms/162zrhs

Thank you,
Tamir