I think Palmetto was simply making the point that if the values in your Row Fields are Numeric you should store them in the Data Field and use a simple Number Format (as per his sample).
If the source values can not be changed and said values are non-numeric then I guess you could use VBA
The point is basically that a Pivot Item can not be Null / Blank so in the above the "(blank)" text string is replaced with a space.
(remember to change the PT specifics in the code to match your requirements - ie sheet name, pivot table name)
You could equally apply Conditional Formatting etc to set font to white etc etc...
(I remained convinced there's a more elegant method than the above)
Bookmarks