I have a list of data and one of the fields is YES, Recommend Our Company or
NO, Don't Recommend Our Company. We are trying to calculate the percentage of
YES answers and use the result in a pivot table. The YES/NO answers are part
of a list of other customer survey questions that we are mapping in a pivot
table. In summary, I need to see % of YES answers by customer type in my
pivot table.

Any recommendations.

=COUNTIF(range,"YES")/COUNTA(range)
formatted as %. Not sure what this has to do with charting.

Jerry

Robert Mitchell wrote:

I have a list of data and one of the fields is YES, Recommend Our Company or
NO, Don't Recommend Our Company. We are trying to calculate the percentage of
YES answers and use the result in a pivot table. The YES/NO answers are part
of a list of other customer survey questions that we are mapping in a pivot
table. In summary, I need to see % of YES answers by customer type in my
pivot table.

Any recommendations.

The formula provided is helpful. However, the problem is when I put the data
into a pivot table for charting purposes. Can I use the formula in a pivot
table and can I calculate the percentage for each customer type, not just for
the entire data set?

"Jerry W. Lewis" wrote:

=COUNTIF(range,"YES")/COUNTA(range)
formatted as %. Not sure what this has to do with charting.

Jerry

Robert Mitchell wrote:

I have a list of data and one of the fields is YES, Recommend Our Company or
NO, Don't Recommend Our Company. We are trying to calculate the percentage of
YES answers and use the result in a pivot table. The YES/NO answers are part
of a list of other customer survey questions that we are mapping in a pivot
table. In summary, I need to see % of YES answers by customer type in my
pivot table.

Any recommendations.