You can filter any row/column field to not show the Blank item
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 ...
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.
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.