How do I get "(blank)" from appearing in the pivot table when there is no data in a field? For example, my column looks like:
(blank)
X
X
(blank)
(blank)
(blank)
I have tried "For Empty Cells Show" in the Table Options and what I indicate in the box does not show up.
Thks.
Mary
(blank)
X
X
(blank)
(blank)
(blank)
I have tried "For Empty Cells Show" in the Table Options and what I indicate in the box does not show up.
Thks.
Mary