Pivot table calculated fields using sum and count

[Uganda]

Hello

In my pivot table I have a sum field (counts the total of a field where the response is 1 for yes and 0 for no) and the count of another field which will basically count all records.

I was hoping to add a calculated field to give me the % i.e. how many yes out of the total. I've searched forums for this and it seems the problem lies with the count field. I have tried creating another count field but this only shows 1.

Is it possible to do this sort of calculated field in a pivot table please?

Look forward to your thoughts!

Thanks!