Pivot table - filtering out rows that have blank columns

  • Thread starter Thread starter mbuckley
  • Start date Start date
M

mbuckley

I have a pivot table that I would like to hide a row if a certain
column is blank.

For example:

Column Heading A | Column Heading B | Column Heading C
Animal | Dog | 4
Animal | | 5
Animal | Cat | 10

etc...

So I would like to be able to hide row number 2 from the table.

How complicated is this to do?
 
The other thing is that the blank column is a data column, so I cannot
uncheck the "blank" option in the column heading dropdown.
 
Back
Top