Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot and count question.
Hello,
I have the following pivot table with Row column being State Name and county Name with Population as Data. How would I be able to count the number of county name in each state? My main grid has the name of each of these members with the state and county. State Name County Name Population New York Kings 1.1 mil Queens 1.2 mil Bronx 2.1 mil Richmond .5 mil New York Total 4.9 mil New Jersey Bergen 3.5 mil Elizabeth .58 mil New Jersey Total 4.08 mil Texas |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot and count question.
Right click on Pivot Table, Show Field list. Drag "County Name" Over into the
data area. (should not be in both the row and data areas). Right click, field settings, change as needed. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* " wrote: Hello, I have the following pivot table with Row column being State Name and county Name with Population as Data. How would I be able to count the number of county name in each state? My main grid has the name of each of these members with the state and county. State Name County Name Population New York Kings 1.1 mil Queens 1.2 mil Bronx 2.1 mil Richmond .5 mil New York Total 4.9 mil New Jersey Bergen 3.5 mil Elizabeth .58 mil New Jersey Total 4.08 mil Texas |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot and count question.
HI,
Right click the field you want to count, Countries or Cities and choose Field Settings, and set the Subtotals to Count -- If this helps, please click the Yes button Cheers, Shane Devenshire " wrote: Hello, I have the following pivot table with Row column being State Name and county Name with Population as Data. How would I be able to count the number of county name in each state? My main grid has the name of each of these members with the state and county. State Name County Name Population New York Kings 1.1 mil Queens 1.2 mil Bronx 2.1 mil Richmond .5 mil New York Total 4.9 mil New Jersey Bergen 3.5 mil Elizabeth .58 mil New Jersey Total 4.08 mil Texas |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot and count question.
On Jan 29, 4:05*pm, Shane Devenshire
wrote: HI, Right click the field you want to count, Countries or Cities and choose Field Settings, and set the Subtotals to Count -- If this helps, please click the Yes button Cheers, Shane Devenshire " wrote: Hello, I have the following pivot table with Row column being State Name and county Name with Population as Data. *How would I be able to count the number of county name in each state? *My main grid has the name of each of these members with the state and county. State Name * * *County Name * Population New York * * * * *Kings * * * * * * *1.1 mil * * * * * * * * * * * * Queens * * * * * *1.2 mil * * * * * * * * * * * * Bronx * * * * * * * 2.1 mil * * * * * * * * * * * * Richmond * * * * .5 mil New York Total * * * * * * * * * * * *4.9 mil New Jersey * * * *Bergen * * * * * *3.5 mil * * * * * * * * * * * * *Elizabeth * * * * .58 mil New Jersey Total * * * * * * * * * * *4.08 mil Texas- Hide quoted text - - Show quoted text - That will give me the number of times that county shows up and that county name is being repeated for each member. I only want the unique count of the number of county in New York. In my example, it would be 4, for NJ it would be 2. I hope my explanation is clear. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNT QUESTION | Excel Discussion (Misc queries) | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Worksheet Functions | |||
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable | Excel Discussion (Misc queries) | |||
Day Count Question | Excel Discussion (Misc queries) | |||
pivot table question about count and totals | Excel Discussion (Misc queries) |