pivot table (blank)

[Tuxla]

I have created a pivot table, but the (blank) field is n longer showing the
number of blank entries, it's just blank! I'm guessing it's an easy thing to
change because it used to work!
Example below - I have 5 with the name ABCDE and I also have some that are
blank, but although it's showing (blank), there is no number in there. If I
change the "for empty cells show...0" field in table options, it shows as 0,
even though it shoudn't be empty

name number
ABCDE 5
(blank)
Grand Total 5

Thanks

 

[Don]

I see your issue and there are a few ways to solve this.
One is to put a charactor (like ".") in the blank fields
two would be to use the =COUNTBLANK function to solve the blank line and
=countif for the other ones
Not sure if you are trying to Sum , but SumIf() could be used to sum amounts

I have found that I love pivot tables , but I can do Sumif, Countif's to get
a similar result with less memory usage.

good luck

 

[baldmosher]

I've just suffered exactly the same problem: what used to be "(blank)" now
appears as "" ....I'd love to know what I've done to make this happen!

I'm not trying to count the blanks so the solution above doesn't work for me.

Oddly, when recording a macro to change the pivot page fields, the code
recorded as "(blank)" but the macro wouldn't work when I ran it.

My workaround was simply to change my macro code for the pivot selection as
follows:

was
..CurrentPage = "(blank)"
now
..CurrentPage = ""

This seems to have done the trick but I am concerned that the data might
flip back to (blank) at some point without warning.