Pivot Table Calculations Help

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!

Thank you for your response! Unfortunately it is not what I need. The issue I'm running into is the calculation since the headcount is a static number per location, but I can't figure out how to incorporate it into a pivot table value.