Performing Calculations on Summary Data in a Pivot Table

[rjbinney]

I have a big honking sheet with the following fields:
- Contractor
- Date of Work
- Work Order Number
- Operation Number (of work order)
- Scheduled Duration
- Actual Duration

Because there are a number of operations per work order, and one work order can be done over different days, I created a Pivot Table:

FILTER BY:
- Contractor
- Date of Work
- TYPE of Work Order

ROW:
- Work Order

COLUMN:
- Sum of Actual Duration
- Sum of Scheduled Duration

I'd like to calculate percent time-to-complete (that is, =Actual/Scheduled) PER work order. (And, then, obviously, filter by Contractor, day of week, etc.)

I keep finding things about performing calculations on pivot reports, but I'm clearly missing something.

I'll take any and all suggestions.

Thanks

rjb

 

[rjbinney]

Got It! Formulas=>Insert Calculated...