9 Oct
2006
9 Oct
'06
2:48 p.m.
Todd, Check your pivot table LAYOUT screen. It sounds like you have "Sum of GENDER" rather than "Count of GENDER" in the DATA section. I assume you have GENDER in either column or row. Jamie
In EXCEL, on a 2X2 pivot table where Im looking at gender, 'male = 1' and 'female = 2' for data entry. If there are 11 'females' that should be represented in a box, it gives '22'...I assume somewhere the 11 females are being summed (2 X 11).
Todd