Once you've dropped your yes/no field into the "Drop Data Fields"
section, drop it again into the "Drop Column Fields" section. Then you
can uncheck "no" from the data menu.


Jim



Teresa wrote:
I have an EXCEL spreadsheet where one colum is populated with either YES or
NO as a result of comparing two dates in two other fields. I am building a
PIVOT table and would like to count ONLY the "yes", but, the pivot is
counting the yes and no. So the total is off. Does anyone know how I can
set up a calculation in the pivot table so that it ONLY counts the Yes's?
--
T