I currently have a spreadsheet that contains all the works orders currently
in production, the part number, which press they run on, the outstanding
quantity, the rate per hour and when the operations is due.

I have created a pivot table to show all the jobs per press, the outstanding
quantity, the rate per hour per part for each week.

What I am wanting to do is show the total hours per part, per press for the
operation due week.

I created a fomula to divide the outstanding quantity by the rate per hour,
this works ok if the is only 1 works order, but if there are more it then
divides the result by the number of works orders.

Is there anyway to stop this?

Regards

In the source table, you could add a new column, and calculate the Hours
for each item.
Then, add that field to the pivot table, and you should get the correct
result.

TheRook wrote:
I currently have a spreadsheet that contains all the works orders currently
in production, the part number, which press they run on, the outstanding
quantity, the rate per hour and when the operations is due.

I have created a pivot table to show all the jobs per press, the outstanding
quantity, the rate per hour per part for each week.

What I am wanting to do is show the total hours per part, per press for the
operation due week.

I created a fomula to divide the outstanding quantity by the rate per hour,
this works ok if the is only 1 works order, but if there are more it then
divides the result by the number of works orders.

Is there anyway to stop this?

Regards



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html