Results 1 to 2 of 2
2014-01-23, 15:22 #1
- Join Date
- Jan 2001
- Las Vegas, Nevada, USA
- Thanked 0 Times in 0 Posts
Format for Pivot Table to Hide the "(blank)" result
How can I hide the "(blank)" results in a pivot table when the field data are empty?
I have created a table of results by placing the data fields in only Row Labels. Its a list of customers - I'm trying to print the list to show which customers haven't provided us with an email address. The list would look better without all the "(blank)" results.
Since the field is text, the Number Format options button doesn't appear so that's not an option.
I should have looked just a bit further. I found my answer by trying the Conditional Formatting option "Format only cells that contain" and the I entered "(blank)" in the rule description.
Last edited by Arcturus16a; 2014-01-23 at 15:40.
2014-01-23, 16:57 #2
- Join Date
- Jul 2002
- Pittsburgh, Pennsylvania, USA
- Thanked 342 Times in 335 Posts
You can also filer on that field list in the pivot table and uncheck the "blanks" to not display it. [select any of the items in the list and pick the filter]