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

"Borianita" wrote:

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

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?

"DazzaData" wrote:

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

"Borianita" wrote:

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