Pivot Table - HELP
Posted by Susie on July 20, 2001 9:13 AM
My database contains info. on employees with primary fields:
Cost center, Employee Name, Gender (Male or Female), Race (Minority or Non-Minority), Age (40+ or <40)
I want my pivot table to count the number of employees in each cost center, the number of females and males, minority and non-minority, Age 40+ and <40. Example:
Cost Center 1000 has total employees 40; 25 female employees and 15 male employees; 20 minority and 20 non-minority; 30 40+ and 10 <40.
How do I organize the database and the pivot table to return the data like this?
I tried putting in my DB an IF formula that if gender is female then 1, if not then, 0. If age >40 then 1, if not 0, etc. I was hoping it would count up the number of 1's in the pivot table, but it returns the total -- it counts the same number for female and male.