Pivot Table - suppress (blank)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you suppress "(blank)" from showing up in a pivot table field

Thanks

ak
 
I use a Condition Format that when cell is 'equal to' "(blank)" forma
the cell to white (or you can change the font color to white)
 
Thanks for the heads up... That's the work around I was using. I thought there was an option or something that would turn it off. It shows up on some pivots and not others. Do you know why

Thanks

ak
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Suppression 1
Pivot Table display 1
GETPIVOTDATA and (blank) 0
Remove blank from pivot table 5
Pivot Table Question 1
Pivot Table with Data Model Connection - getpivotdata reference issue 0
count blanks in pivot table 3
How to clear data in pivot table? 4

Back
Top