Build Your Pivot Table

After we have our aggregate formulas created, it’s as simple as throwing the Item Name (from the items table) into the rose section of the pivot table, the available quantity (from the stock inflow table) into the data section, our invoice items aggregate formula into the data section, and our committed stock aggregate formula as well.

Back to Lesson