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