Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table problem, blank fields aren't being added
Hi,
I have a Pivot table pulling data from another workbook. It's displaying a count for given values in 2 columns. It's fine for most of the data, but when one of the columns is blank, it shows a count of 0, even though there are items that are blank. If I double click on the field, it shows me a sheet that contains the data that isn't being counted. Is this a bug in the Pivottable? Is there a way around it? Thanks. Ant |
#2
|
|||
|
|||
Pivot Table problem, blank fields aren't being added
A pivot table can't count blanks. You could type a space character in
those cells, or use a formula: ="" Then, they'll be counted. Ant wrote: Hi, I have a Pivot table pulling data from another workbook. It's displaying a count for given values in 2 columns. It's fine for most of the data, but when one of the columns is blank, it shows a count of 0, even though there are items that are blank. If I double click on the field, it shows me a sheet that contains the data that isn't being counted. Is this a bug in the Pivottable? Is there a way around it? Thanks. Ant -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Pivot Table problem, blank fields aren't being added
Thanks for your reply. But then why is there a category for blanks
automatically added to the pivot table and when I click on show data, it shows the rows that are blank? Thanks. "Debra Dalgleish" wrote: A pivot table can't count blanks. You could type a space character in those cells, or use a formula: ="" Then, they'll be counted. Ant wrote: Hi, I have a Pivot table pulling data from another workbook. It's displaying a count for given values in 2 columns. It's fine for most of the data, but when one of the columns is blank, it shows a count of 0, even though there are items that are blank. If I double click on the field, it shows me a sheet that contains the data that isn't being counted. Is this a bug in the Pivottable? Is there a way around it? Thanks. Ant -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
|
|||
|
|||
Pivot Table problem, blank fields aren't being added
The record has other fields with data, so when you show the detail, it
can show the complete record. If there's no Customer name, it will show (blank) as the Customer item. But, if you add Customer to the data area, as Count of Customer, it can't count anything for those blank cells. You could add a different field, that has data in every row, to the data area, and use it to get the count. Ant wrote: Thanks for your reply. But then why is there a category for blanks automatically added to the pivot table and when I click on show data, it shows the rows that are blank? Thanks. "Debra Dalgleish" wrote: A pivot table can't count blanks. You could type a space character in those cells, or use a formula: ="" Then, they'll be counted. Ant wrote: Hi, I have a Pivot table pulling data from another workbook. It's displaying a count for given values in 2 columns. It's fine for most of the data, but when one of the columns is blank, it shows a count of 0, even though there are items that are blank. If I double click on the field, it shows me a sheet that contains the data that isn't being counted. Is this a bug in the Pivottable? Is there a way around it? Thanks. Ant -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
flattening aggregated fields in pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Fields | Excel Worksheet Functions | |||
refresh of pivot table clears fields (column headers) | Excel Discussion (Misc queries) | |||
Using Pivot Table Function to Summarize | Excel Discussion (Misc queries) | |||
Pivot Table Data Filter Problem | Excel Discussion (Misc queries) |