Remove "(blank)" in a pivot table?
 

Pivot table returns "(blank)" if field is empty. Can this be shut off or
hidden?

Remove "(blank)" in a pivot table?
 

click the pull-down under the label. The clear the check box next to (blank)
--
Gary''s Student


"GunnarX" wrote:

Pivot table returns "(blank)" if field is empty. Can this be shut off or
hidden?

Remove "(blank)" in a pivot table?
 

Select a cell that contains "(blank)", and type a space character.

GunnarX wrote:
Pivot table returns "(blank)" if field is empty. Can this be shut off or
hidden?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html