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.
0
8/5/2005 6:10:04 PM
excel.charting 18370 articles. 0 followers. Follow

2 Replies
418 Views

Similar Articles

[PageSpeed] 20

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

0
post_a_reply (1395)
8/5/2005 6:40:35 PM
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.
> 
> 
0
8/6/2005 1:01:02 PM
Reply:

Similar Artilces:

Can't Open Outlook #12
I have tried so many "fixes", nothing seems to work. I'm using Outlook 2003 on a Vista laptop. Here's the error message"Unable to open your default email folders. The information store store could not be opened" I've tried, new profiles, uinstalling, safe mode etc. Any sugestions What we need to know is what information store you are using and how you configured Outlook to connect to it. We also need to know the steps that created this behavior. -- Russ Valentine [MVP-Outlook] "Ralph" <Ralph@discussions.microsoft.com> wrote in message n...

Percentage problem
Hello, A record can belong to one of three groups and each record has a value attached to it. How can I calculate the total for each group as a percentage of the overall total? like 1 £33 33% 2 £33 33% 3 £33 33% ...

Can Outlook 2007 look like old Outlook versions
I like most of the changes in O2007. But I would like to be able to have the same keystrokes in 2007 had in 2003. For example, I would like F5 to send/receive email. I would like PAGE UP to go to the previous week in the calendar. Any way to do this or am I stuck? BONUS: In the old Outlook I could modify hotkeys . . . I could have ALT-T take me to Go To Today. Can I modify hotkeys in 2007? F5 is history. It's F9 now. How did you change the hotkeys in Outlook 2003? You can add buttons to the toolbar and change the shortcuts, just as before. On the page up/down, It doesn't l...

can not receive mail from hotmail.com
I can no longer receive email from anyone using hotmail.com. I used to be able to receive it, up until possibly a month or so ago. I can send mail to them. I have added them to safe senders list, safe sender domain, changed security settings etc. Does anyone know what I need to do? It does not send them to the junk folder. I just never receive it. The sender has no knowledge that I didn't receive it either. Any help would be appreciated. "Deb" <brunnerdeb@roadrunner.com> schrieb im Newsbeitrag news:u$hQHf9pKHA.1556@TK2MSFTNGP05.phx.gbl... &...

Can I create a book (booklet) in Publisher 2000?
I am looking to buy Publisher 2000, as I have Office 2000, and want to know if I can create a multi-page book or booklet if 25 pages or more in that version. Help would be greatly appreciated. ? You don't have to buy an 8 year old program because Office is 8 years old...you know that right? What OS are you using on your computer. But, yes you can create booklets in Publisher 2000. What you can't do, with any booklet layout in any program, is create a 25 page booklet (the page will fall out) all booklet page amounts must be divisable by 4... 16 pages good, 17 pages bad. -- ...

How can I BULK Convert Leads to Acccounts ??
Hello New, There is not "bulk" procedure with CRM to do this, but you can use the CRM API to create a routine to do this. Kind Regards Eddie Fourie MBS Specialist ...

can't get query to group
here is the sql. can someone help me determine why the query isn't grouping by GoupNumber? The GroupName is the same for the GroupNumber. ID is unique. SELECT Mid([ID],3,2) AS GroupNumber, Accounts.GroupName FROM Accounts GROUP BY Mid([ID],3,2), Accounts.GroupName, Accounts.ID HAVING (((Accounts.ID) Like "01*")); Example ID GroupNumber GroupName 010101 01 red 010102 01 red 010201 02 blue 010301 03 ...

Pivot Table
As with a previous question, I have a large set of data (20,000 rows and about 100 coulmns). I wish to select about 60 columns to place in pivot "data" (along with others into "Rows"). Is there a way to select multiple columns (say all 60?) and move into "Data" in one step? Are there add-ins that help with this? Doing all 60 is possible but slow and somewhat error prone. Thanks in advance. Hi Johnny The following code should get you started on what you want to do. In this example the first column of source data is added to Page area, the seco...

how do I calculate times and get as a result numbers
I got a Spreedsheet that I whant to use as a time sheet, this is so far what I got done wrong what I want to get is right a1= 10:00am time in a1= 10:00am b1= 2:00pm time out (lunch) b1= 2:00pm c1= 2:30pm time in (lunch) c1= 2:30pm d1= 8:00pm time out d1= 8:00pm e1= 8:30 total e1= 8.5 the answer has to be a number if the time is #:0<= #:14 = #.0 #:15<=#:29 = #.25 ...

How to aviod reset of Pivot filters when reconnecting to database?
I have a large amount of Excel pivots feeding on MS Access databases. However, these databases have moved location and I need to reconnect the Pivots. When I do this, I loose all the filters I have applied. Does anyone know how to avide the resetting of these filters? It'll be a great help to me as I have a lot of pivots... Thanks, Tonny How are you reconnecting? What filters are applied? Tonny Olesen wrote: > I have a large amount of Excel pivots feeding on MS Access databases. > However, these databases have moved location and I need to reconnect the > Pivots. > Whe...

Activating Field Level Security
We were just wondering how to activate field level security. We are using advanced security, and it shows that field level security should be available on the menus, but we're not sure if this is an extra module or not. If so, any info or fact sheets would be appreciated. Thank you. The menu option "Field Level Security " is available in System Setup menu. Setup->System->Field Level Security "ConnollyandCo" wrote: > We were just wondering how to activate field level security. We are using > advanced security, and it shows that field level security...

How can I convert an Excel file to someone who doesn't have Excel.
That's it. I have a large Excel file which I want to send. The receiver doesn't have Excel and can't read the file. He says he can read TXT,DOC,HTML and RTF. I can't typoe it all in again in Word (it's a big file) so is there an answer? Copy-and-paste from the Excel file into a text or Word file. In the Excel file, hit: <Ctrl>A <Ctrl>C Then, open a text or Word document, and hit: <Ctrl>V Regards, Mark Have them download the FREE Excel Viewer. "donnythejazz" <donnythejazz @discussions.microsoft.com> wrote in message news:D4E5A20...

newbie: How can I get the querystring from the presenter?
Hi asp.net 4.0 vs2010 I wonder how I can get the querystring from within the presenter? Jeff wrote: > Hi > > asp.net 4.0 > vs2010 > > I wonder how I can get the querystring from within the presenter? > > What presenter? Sorry, I thought there was only one type of presenter in the .net framework "Mr. Arnold" <Arnold@Arnold.com> wrote in message news:%23P0csJGHLHA.1972@TK2MSFTNGP04.phx.gbl... > Jeff wrote: >> Hi >> >> asp.net 4.0 >> vs2010 >> >> I wonder how I can get the ...

CAN'T SAVE error
Outlook could not save the updated folder shortcut information. Check to make sure there is sufficient disc space and that the file "C:\Documents and Settings\Jack\Application Data\Microsoft Outlook" is not marked read-only. Another attempt to save will be made after the next change when you exit. You don't have the appropriate permission to perform this operation ...

How can I auto display email address in outlook 2003.
Dear all, I have installed outlook 2002 in my computer (Windwos XP professional). Would you please help me how can I auto display email address in outlook 2002. I know that the email address can be auto display in outlook 2002 when type more than 3 character. However, it cannot auto display email address when I type more than 3 characters. Tks & B.rgds Ping Ping The automatic display of names will not occur until you have entered enough names for Outlook to build its cache. It does not use the address book for this option. --� Milly Staples [MVP - Outlook] Post all replies to ...

Color Tabs
I've been messing around trying to come up with an easy way to color code the worksheet tabs. Any ideas? SAM Samuel, Only available in XL2K2 (XP). Regrets, Andy ...

VBA
Hi all, I am using Exel 97 and I am trying to put a macro together that refreshes a pivot table after new data is inputted. The data and the pivot table is in worksheet 1. The pivot table can change size depending on the number of cells with data in it. I have set up a button (or should I say Exel automatically set up a button) called "CommandButton1". This links to the following VBA: Private Sub CommandButton1_Click() ActiveSheet.PivotTables("PivotTable2").RefreshTable End Sub When I press the button I receive the following message: Run time error '1004': ...

Can't add field by deployment manager
Hi all I have two questions about ENTERPRISE_NAME_MSCRM data base, any help is very apreciated. First, I can´t add fields via Deployment Manager, I get the following error messages when trying to add a field: dmLog: sp_repladdcolumn failed. - No se pudo agregar la columna 'CFMProductExtra' a la tabla 'InvoiceDetailBase'. dmLog: Failed to add new Memo attribute (CFMProductExtra) to InvoiceDetail entity. The second question is about extra tables in that MSCRM data base. In the SQL Server Enterprise Manager, when i look in the Tables section of the ENTERPRISE_...

Fraction and age calculation
Two questions: 1. I am trying to enter a fraction into a cell but it keeps reducing i to the lowest common denominator. How do I get it to keep the exac fraction I've entered? 2. How do I calculate how old a person is, displayed as a single an whole number, given their date of birth and todays date. My date o birth cell is J6 and the age cell is J7. Thank -- Message posted from http://www.ExcelForum.com Hi milesryl! Try to keep to one question per thread. Fractions: Use a custom format to avoid the fraction simplifying: eg # ??/12 Will display (eg) 5 6/12 Age: Assuming you w...

Getting Exchange Tabs on Domain Controller AD users &computer
I have a DC that when you go to AD users & computers and double click a user, the exchange tabs are not present. How can I get them on there? Install the Exchange System Manager, by running a custom install of Exchange on that DC, remember to apply the Exchange service pack as well. -- Mark Fugatt Exchange MVP http://www.exchangetrainer.com http://www.msexchange.org "Mark" <mercado@diahome.org> wrote in message news:f65201c43de2$f0b84d50$a301280a@phx.gbl... >I have a DC that when you go to AD users & computers and > double click a user, the exchange tabs are...

how to thread DLOOKUP result into "<tab>" "getLabel" in Ribbon XML
Hi, I can easily pull astring from a table into the button control and the group control on a Ribbon menu using a query and sending the result to the "getLabel" attribute of the control in the XML for that ribbon. However, the "<tab>" control does not accept this way of accepting a string, complaining of it being a null (which I have tested it not to be) Can anyone tell me why? Thanks PAul On Wed, 27 Jan 2010 04:53:01 -0800, Paul C <Paul C@discussions.microsoft.com> wrote: >Can anyone tell me why? Not without seeing your code. -...

Adding text content to Memo field
I have two memo fields, Memo1 and Memo2. Memo1 cannot be edited (its locked property is set to true). So I have the user enter text notes in Memo2, and then I have a command button that allows the user to add the contents of Memo2 to Memo1with the current date. My code is as follows: Me!Memo1 = vbCrLf & Format(Date, "mm/dd/yyyy") & vbCrLf & Me!Memo2 & vbCrLf & Me!Memo1 Now I am recieving an error message: "Could not update. Currently locked by another session on this machine". I belive I have about 72K characters in the Memo1 field and was wondering if ...

Can my MFC Regular DLL run in C++ and Visual Basic?
I have an MFC based dialog application that I want to convert to a DLL. So, as a test, I created a simple MFC Regular DLL that is statically linked to MFC. The DLL has two functions: one to add two ints and return the result and the other to run a dialog contained in the DLL. I can build a simple MFC client app to test the DLL and it works. But when I try to run the DLL using Visual Basic I get a 'Bad calling convention' error. Apparently, this can be solved by adding _stdcall to the exported functions. As I understand it, the problem is due to the fact that there is a difference ...

Some items can't be send in outlook 2003. Even after repeatly clicking the send button.
Hello, Does anybody know why some messages can't be send? and stay in the outbox. Even aftyer opening them and trying to send them again and again. I did scan the Outlook.pst file with SCANPST.EXE but no problems were detected. When I copy all contents to a new empty message the message will be so I can't figure out what the problem is. It happens sometimes and all I can do now i placing the contents it a new empty email. There is no logical explanation for this. baarts <pietje@hotmail.com> wrote: > Does anybody know why some messages can't be send? and stay in ...

pivot table 2000 -> 2002 upgrade error
I have recently upgraded to 2002 from 2000. I have a Pivot table that I use to create reports from my company's time accounting system. I used a saved web query to pull an html table into the spreadsheet, and then refresh the data. I do this every week when time is updated. The pivot table summs the data nicely based on client, project, you get the idea. The format of the time value cell (the hours that people work) has always been General. It still is. However, now in 2002, the pivot table does not read the number as a value that it can sum. My pivot table only display zeros. I h...