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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top