Pivot Table cell values

[Jigsy50]

Hello,

I am trying to convert cells on pivot table with "(blank)" as the cell values to empty cells. Is there something in the Pivot Table Options that could resolve this issue? I'm not sure how to resolve this issue.

Jigsy50

 

[Jigsy50]

I highlighted the whole spreadsheet. Then I did a find on all cells with (blank) values and replaced all cells with a space.