How to avoid blank cell in Pivot table

Here is the only way I could get it to work. I did find and replace. Replaced (blank) with … and then I changed the font color in that row to the same color as my background :D. I guess I didn’t have to find and replace, but it makes it look like it isn’t there and it is not adding the blank rows to my count.

1 Like