Hello,
I am trying to create a calculated field that is based off of the same field.
For example, I have a field in my pivot table named 'Answer'
The Choices are: Yes, No , N/A.
Currently I have it displaying the count of 'No's for each row.
I would also like to create a field that shows the % of No's for each row. (No/Yes+No).
Each row is a different question listed so each question is answered numerous times.
Thank you in advance.
I am trying to create a calculated field that is based off of the same field.
For example, I have a field in my pivot table named 'Answer'
The Choices are: Yes, No , N/A.
Currently I have it displaying the count of 'No's for each row.
I would also like to create a field that shows the % of No's for each row. (No/Yes+No).
Each row is a different question listed so each question is answered numerous times.
Thank you in advance.
