Forum Discussion
Pivot tabe shows "(blank)" even if "For empty cells show" is set to empty
How is this possible? Source cells are empty...
This setting works for values, not for rows labels.
In row labels as variant you may double click on any cell with (blank), aka edit it, and enter any desired text or space.
4 Replies
Hi bartvana
this setting just appies to fields in the value area of the pivot table. It has no effect on fields in the rows or columns area, which is the case in your example.
The only way to suppress "(blank)" in row or colum fields is to create conditional formatting rules.
Martin_Weiss SergeiBaklan That's very clear, thank you both!
bartvana , you are welcome
This setting works for values, not for rows labels.
In row labels as variant you may double click on any cell with (blank), aka edit it, and enter any desired text or space.
