how do I stop showing "blanks" in a pivot table?

B

Borianita

I am working on a pivot table, and I want to avoid showing "blanks" and
counting them, later on I need to do a graph and I do not want the blanks to
appear
 
D

DazzaData

us the dropdowns beside the row and column headers, the grey bokes.

Scroll through the list until you see <blank> and deselect it

They will not reappear until you reselect them
 
K

Ken

Question

If you check the box for blanks (In my case I want to count blanks only) and
deselect everything else it displays the blanks just fine. My question is
this... when I import fresh data and refresh the Pivot it automatically
checks the new "nonblank" entries and skews my results, is there a way to
set the Pivot to always keep (blanks) checked only? I need the new refreshed
data (with new blank data) but not the new nonblank data.

Any ideas?
 
Top