I've searched extensively for solutions to this, but I am at a loss!

I am trying to create a pivot table with calculations based on headcount of each location.

Ideally, I need it to look like this:
HTML Code: 

The LocationHeadcount would be the same for each entry under the specific location, AreaHeadcount would be the total headcount in all locations in that area, and EntireHeadcount would be the total headcount of all areas.

Please let me know if this is even possible!