Inventory

[anonymous123141]

Hello,

I am pulling from two tables, a SharePoint list beginning inventory for each vendor and a SQL database with inventory deductions from vendors that is updated multiple times a day.  I need to make a table that shows the cumulative amount deducted from the beginning inventory.  Is this possible? 

[lbendlin · Accepted solution]

Yes.  What have you tried and where are you stuck?

[anonymous123141]

Thank you for replying.  I forgot to delete my post.  I found a solution through pivoting columns.