count pivot table items

[geebee]

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

 

[Roger Govier]

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.