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!