Counting .5 in a pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You need another column in your data source, with .5 for part-time and 1 for full-time.

HTH,
Bernie
MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of Subtotals in Pivot Table 0
Combine Pivot tables - confused about 'how-to' 7
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot Table Calculations 2
Pivot Table - Calculated Field 2
Count within pivot table 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
Pivot Tables (Sumif) 4

Back
Top