Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    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.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    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]


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts