Pivot Tables

[John]

At the end of my Pivot table there is a column
for "(blanks)". I have set the Field Setting to count.
The "(Blank)" column is supposed to count all the empty
data entries.
It refuses to do anything in the "(blnak)" column. It
remains completely empty regardless of how I setup the
Field or the Table Options.
Does anyone know to to make this work. I am using Excel
2002 on Windows XP.

 

[Mandy]

The reason why it is giving you a blank category without
any data is because when you created the pivot table you
selected the entire workbook (blank rows too) when you
created the pivot table.

The only way to correct it is to change the range to only
include the cells that contain the data.

I know this another annoying thing!!!! I alway choose
all of the cells (1) because it is quicker (2) I update
my reports on a monthly/quarterly basis and next month I
may have more rows of data and I don't want to have to
changed the range for the pivot table each month.

Now, you can "trick" it. Just hide that row.

I choose to ignore "blank".

Hope this helps.


_________________________________________

 

[Debra Dalgleish]

To count the blanks you could use a space character, or the formula ="",
in the source data, instead of leaving the cells blank. The pivot table
will be able to count those.