MRP With a Pivot Table

  • Thread starter Thread starter Mark Bigelow
  • Start date Start date
M

Mark Bigelow

Hello,

I would like to create an MRP tool with an Excel PivotTable. Here's
how the table is set up:

Row Fields
SKU
Plant
Measurement (incoming inventory, outgoing shipments and stock)

Column Fields
Month (day, quarter, week, etc)

Data Field
Quantity

I need to get the PivotTable to take one month's subtotal and add it to
the activity of the next month, to calculate an ongoing net position.
In other words, if we start with 50 units of stock, add 20 and take
away 10, we end up with 60 at the end of month 1. I need month 2 to
start at 60, instead of 0. Does that make sense? If not, please let
me know.

Thanks for your help, in advance.

Mark
 
Back
Top