LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Robert Mitchell
 
Posts: n/a
Default How can I calculate a percentage of a YES/NO field in a Pivot Tab

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Want to calculate a percentage by dividing one cell by the other, KMHarpe Excel Discussion (Misc queries) 2 July 21st 05 11:09 PM
HOW DO I CALCULATE A RUNNING PERCENTAGE fniguy24095 Excel Discussion (Misc queries) 1 May 4th 05 08:12 PM
Calculate percentage based on cells with conditional formatting Cachod1 New Users to Excel 5 April 4th 05 02:11 PM
calculate percentage JP Excel Worksheet Functions 6 March 2nd 05 02:34 PM
calculate percentage of two cells Suzie Excel Worksheet Functions 4 December 3rd 04 05:27 PM


All times are GMT +1. The time now is 12:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"