Pivot Table Hide (Blank)

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Pivot Table Hide (Blank)

  1. #1
    Board Regular
    Join Date
    Jul 2009
    Location
    Ohio
    Posts
    77
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Unhappy Pivot Table Hide (Blank)

     
    I have a PivotTable I am trying to use as a Chart of Accounts to display parents and children of accounts. I have multiple levels and come to a point where I have empty (blank) cells that are in the Pivot Data. In the PivotTable, I need the (Blank) not to appear. Has anyone figured out a way to basically hide any rows that show blank cells?

    Sorry, I can't figure out how to add an attachment.

  2. #2
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    30,754
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot Table Hide (Blank)

    You can filter any row/column field to not show the Blank item

  3. #3
    New Member
    Join Date
    May 2011
    Location
    TN
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot Table Hide (Blank)

      
    The pivot table is still just data so you can apply a regular filter for the whole column. My table shows data for Jan through May and for most rows, the grand total is zero. If there's a number, it means there's an error and I want to see only the errors. So I put the filer on the whole column, filter out the zero, and my 800 lines is now just 17 errors to be investigated.
    Last edited by JTPigskin; Jun 28th, 2013 at 06:44 PM.

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com