Pivot tabe shows "(blank)" even if "For empty cells show" is set to empty

[bartvana]

How is this possible? Source cells are empty...

[#2 · Accepted solution]

@bartvana 

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.

[#3]

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.

[#4]

@Martin_Weiss @Sergei Baklan That's very clear, thank you both!

[#5]

@bartvana , you are welcome