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