pivot table and ignore blanks

W

Woody in Weitchpec

My pivot table counts nulls in the data range as "blank". How can I make it
ignore blanks (nulls), or better yet, ignore values that I specify, in a data
range?
 
D

Dave Peterson

Can't you choose to just show the values you want--use that dropdown like arrow
in the header to show just the ones you want.

I sometimes add another column to my data table.

I put a formula in that column:

=if(or(a2="",b2="bad",c2="something"),"don't show","show")

Then I can use that as a page field and just show the ones I want/don't want (or
even all).
 
Top