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