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 |
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) |