need to show % diff of two other columns in pivot

[Egunner]

I have a pivot that shows total available up time and total down time on certain manufacturing lines in our plant. I need to create a third column in the pivot that shows a percentage that the down time is of the total available up time. Can someone tell me step by step how to gett hat to come out in the pivot so I can chart off it?


Data
Line Sum of Available Up Time Sum of Down Time
18 95,040 2,406
19 146,880 3,059
20 51,840 1,359
26 224,640 4,292
Grand Total 518,400 11,116

Thanks!

[T-J]

Insert a calculated field into the pivot table with the following:

Name: DT as percentage of UT
Formula: ='Down Time' /'Available Up Time'

After adding the new field change the Number Format in its field settings to Percentage.