To alter the error display, pick out the For error values clearly show Verify box. During the box, type the value that you would like to display in lieu of problems. To display mistakes as blank cells, delete any people during the box.

You could pick from a wide variety of PivotTab