I have learned to use GETPIVOTDATA to retrieve numbers aligned with employees
names. When an employees name does not appear on the pivot table, it returns
#REF!, which can be turned into 4 with the ERROR.TYPE command. I can turn
the 4 into a 0, but then when the number is not a 4, I get #N/A.

Is there any way to get a 0 off of the pivot table if an employee name does
not show up?