Hide completely blank value rows in a pivot table

excelbarn

New Member
Joined
Mar 31, 2016
Messages
1
I have a pivot table that is showing two values. However, some rows have zero for both values, some rows have both values, and some rows just have one of the values. If I use a filter for one of the value columns is hides the row irrespective of a value in the other column. I need some way to have multiple value filters that don't hide the entire row of one of the columns has a value.
 

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

ktielens

New Member
Joined
Oct 26, 2015
Messages
23
Hi,

Right click on the pivot table and select Pivot table options. Go to the display tab (3rd one over) and toward the middle there are some choices including "show items with no data in rows" and "show items with no data on columns". Try unchecking the rows one and see if that fixes it.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,291
Messages
5,577,223
Members
412,777
Latest member
jmulldome
Top