MRP With a Pivot Table

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Fields in Pivot Table 2
Hide Subtotals in Pivot Table for Certain Columns 1
Adding Data/Criteria to a MRP system 2
Help with Pivot Table Code Please 2
help with Pivot table 1
relative reference pivot table macro 2
Pivot Table Code - Is there a better way? 2
Creating a Pivot Table with a named range 3

Top