Ok I've seen a few post about this, but none of them seem to be working for me. Here is a sample of my pivot table.


Data
Equipment Description Count of WO No Count of Task No
Falcon Wash 559 544
Makino1 206 196
ECM 205 157
Kremlin(Gray) 202 200
Kremlin(Green) 202 201
Kremlin(Yellow) 202 201

Where 'Count of WO No' is the total number of work orders per machine and 'Count of Task No' is the number of WO (work orders) that are Tasks (Preventative maintenance measures).

What I need to chart is the percentage of WOs that are NOT Tasks.
I know the formula to find this info but I need to know how to get in a table that will update with the rest of the workbook.

formula = (WO-Task)/WO*100
i.e. (559-544)/559*100= 2.7% which means that 2.7% of the total (Falcon Wash) WOs are not Tasks.

The WO and Task info is pulled from a MS database (if that makes a difference)

I have roughly 300 machines that I need to track on a monthly basis, so entering this info manually is not an option.

Your help is much appreciated.

Terry