How can I calculate a percentage of a YES/NO field in a Pivot Tab

G

Guest

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.
 
J

Jerry W. Lewis

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

Jerry
 
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot tables and dynamic columns 4
Analysing Percentages in Pivot tables in Excel 2003 2
Pivot table - Problem with % 5
How to stop pivot table crashing in Excel 2007 0
Pivot table for worksheet text fields? 2
Pivot Table - Calculated Field - Percentage - Rept 2
Excel How to preserve column fields in a specific order in a pivot table? 2
Percentage of parent row in Pivot Table 1

Top