I'm working on a headcount sheet and want it to reflect the total number that I have within a department for a particular year and beside that bar graph I want to show the number that reflects the amount that I'll lose.
In 2018, I might have 45 people total in that department and I'll have 10 of those individuals leave in 2018. I want to show the number 45 total beside the 35. Then in 2019, I have 35 people and expect to lose 5. I want that number then to say 35 and 30.
Can anyone help me with this?
Hi Josh,
Not exactly sure with seeing your example does not match to the data anyways, something like this?
Thanks,
Shin