How to get ratio of specific dimension within a chart?

[scheibercamo]

If I have a table such as the below (a straight table or pivot), is there a way to get the % Headcount of specific locations, and not just overall Headcount globally? 

I need "% of Location" populated without manually writing the Location in a set analysis. 

% of Total HC I already have - SUM(Headcount) / SUM(Total(Headcount))

So now I need % of Location (text in red). Any way to do this? Much appreciated!

Location	Project	Headcount	% of Total HC	% of Location
San Jose	Auto	89	5%	100%
Chicago	Banking	67	4%	46%
Chicago	Health	78	5%	54%
Tampa	Health	345	23%	28%
Tampa	Auto	890	59%	72%
Buenos Aires	Banking	42	3%	100%
-	Total	1,511	100%	-

[Saravanan_Desingh · Accepted solution]

Try this,

Dim: Location, Project

Exp:

Sum(Headcount)/Sum(TOTAL Headcount)

Sum(Headcount)/Sum(TOTAL <Location> Headcount)

[scheibercamo]

This is literally exactly what I wanted to see - thank you so much! The real MVP!