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!
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!
