You need another column in your data source, with .5 for part-time and 1 for full-time.

HTH,
Bernie
MS Excel MVP


"mtcurtis" wrote in message
...
I have a pivot table of employees. Some of the employees work part-time and
are counted as .5 headcount. Can I get the pivot table to count .5 for those
employees?