Formula - % of total

[IreneTrieu]

Good morning,

Can someone please help me with the formula for the below (see input table below).  I need to calculate the % split by total headcount (ie. 6  headcount / 14 sum of total headcount =  0.425871)

Thanks in advance

Irene

Input:
CITY	Dept #	Headcount
YORK	ABC	6
PEEL	DEF	5
TORONTO	GHI	1
MARKHAM	JKL	1
SCARBOROUG	MNO	1
Output:
CITY	Dept #	Headcount	% split
YORK	ABC	6	0.428571
PEEL	DEF	5	0.357143
TORONTO	GHI	1	0.071429
MARKHAM	JKL	1	0.071429
SCARBOROUG	MNO	1	0.071429

[Qiu · Accepted solution]

@IreneTrieu 
Personally I like to use the Transpose and Cross Tab to do this kind of issue.

[IreneTrieu]

Thank you for the quick reply.  Is there a shorter or quicker way of doing this?

[binuacs · Accepted solution]

@IreneTrieu Another option

[Deano478 · Accepted solution]

@IreneTrieu  Similar to the guys here another way of doing this: