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

Try this:

Drag the Yes/No field into the ROW area AND the DATA area.

That should create a Yes field and a No field on the left with their
respective counts in the data area.

To only see the Yes category, click on the column heading and uncheck No.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"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

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