Results 1 to 3 of 3

Pivot Table Hide (Blank)

This is a discussion on Pivot Table Hide (Blank) within the Excel Questions forums, part of the Question Forums category; I have a PivotTable I am trying to use as a Chart of Accounts to display parents and children of ...

  1. #1
    Board Regular
    Join Date
    Jul 2009
    Location
    Ohio
    Posts
    53

    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
    East Sussex
    Posts
    22,844

    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
    3

    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 05:44 PM.

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