Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MRP With a Pivot Table
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming |