| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Counting .5 in a pivot table
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? |
|
#2
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting in pivot table | Excel Worksheet Functions | |||
| Change Data In Pivot Table | New Users to Excel | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
| Counting blank cells in Pivot Table | Excel Worksheet Functions | |||
| Pivot table and counting | Excel Worksheet Functions | |||
Hybrid Mode
