I am not exactly clear on what is happening, but try to change the pivot table properties by right-clicking within the page area, then change the fields "for error values show" and "for empty cells show". Set these to zero. That may help.