Count in Pivot Tables

J

Joey041

Hi,

What formula would I use (or can I use one) in Pivot Tables to get a Count
of the "Yes" in a column instead of a total of the column Q.

Normally I was use the Countif formula but I can't get it to work.

Thanks
JoAnn
 
J

Jim Thomlinson

Place the field with the yes values in the left column (you will get a
listing of all of the possible values that are in that column). Now just add
the same field again but place it in the center section. This should give you
a count of all of the yes values (along with the rest which you can just
hide)...
 
Top