Excel pivot add field base on two other calculated fields

Question

I added two columns to my pivot which calculates sums of hours like this :

I would like to add another column which is based on those two new columns, that calculates their quotient 'Sum of Avail Hrs'/'Sum of Eff Hrs' but couldn't find how to do it.

Please help! Thank you

(There is a question asked a bit similar to my issue but there is no answer to it.)

Answer 1

You need to create a calculated field to do this.

In that pop-up box, you can create the formula you want.

Then add it to your pivot table.