How to make Pivot Table field count show as negative?

[ChrisSoNH]

Hello and thank you for reading my question.
I’m building a pivot table to tabulate the employee count of my company as of a certain date. I’m simply counting the total number of employees labeled as Current, New Hire, Re-hire, and Terminated. In order to arrive at the correct number of employees, the Terminated employees must reflect as negative. Is there a way to change the pivot table result so those Terminations subtracts from the total number of employees?

Sincerely,
Chris

 

[RoryA]

If you can add a new column to the source data, I'd use a formula that returns 1 for Current, New Hire, and Re-hire, and -1 for Terminated. Then use a Sum on that field.

 

[ChrisSoNH]

RoryA, thank you for that suggestion!

 

[Joyner]

If you can add a new column to the source data, I'd use a formula that returns 1 for Current, New Hire, and Re-hire, and -1 for Terminated. Then use a Sum on that field.

Am I looking at this correct, should the Terminated = zero (0)? to get the proper count?

 

[RoryA]

Not based on the original description, no. I agree it would be more logical to me.