Calculating in Pivot Tables
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
|