hi,

i have a pivot table which includes a column based on the [cat] column.
well i ant it to show a count for this column. well the only problem is that
in this column there apears either the word "cat" or " ". so its not actually
a null value. how can i add a calculated field to the pivot table to get
this to work without first trimming all the values in this column?

thanks in advance,
geebee

Hi
Add another column to your source data called cat2.
Assuming cat is in column C, use the formula
=IF(C2="cat",1,"")
Copy down as far as required.
Use cat2 in the PT in place of cat.

--
Regards
Roger Govier

"geebee" (noSPAMs) wrote in message
...
hi,

i have a pivot table which includes a column based on the [cat] column.
well i ant it to show a count for this column. well the only problem is
that
in this column there apears either the word "cat" or " ". so its not
actually
a null value. how can i add a calculated field to the pivot table to get
this to work without first trimming all the values in this column?

thanks in advance,
geebee