hide (blank) in pivot table
In your pivot table click on a cell with a (blank) and put a space there.
All the (blank) items in that column should vanish.
"Nynke" wrote:
Dear All,
I created a pivot table where the empty cells are represented by (blanks).
By clicking on table options and selecting 'for empty cells show' I tried to
get rid of this (blank) description in my cells. However it will not go away.
Has anyone a suggestion for this problem?
Thanks a lot in advance.
Kind regards,
Nynke
|