Powerpivot Slicing Employee Turnover

[nrarsenb]

I have a spreadsheet with columns labeled with Dept #, position titles, headcount and number of terms and the turnover % for a specific period of time. When I slice the data by depts, my turnover % is not accurate because my only options from the pivot table are to sum, average, min, max or index. Here is an example of my current data:

Dept #</SPAN>	Position Title</SPAN>	Q4 2013</SPAN>	Total Terms</SPAN>	Turnover %</SPAN>
1</SPAN>	Manager </SPAN>	1.75</SPAN>	1.00</SPAN>	57%</SPAN>
1</SPAN>	LPN</SPAN>	21.75</SPAN>	1.00</SPAN>	5%</SPAN>
1</SPAN>	Practice Manager </SPAN>	0.83</SPAN>	1.00</SPAN>	120%</SPAN>
2</SPAN>	RN</SPAN>	37.33</SPAN>	10.00</SPAN>	27%</SPAN>
2</SPAN>	Clinical Manager</SPAN>	2.00</SPAN>	1.00</SPAN>	50%</SPAN>
2</SPAN>	RT</SPAN>	2.00</SPAN>	1.00</SPAN>	50%</SPAN>
3</SPAN>	Supv Cafeteria</SPAN>	1.92</SPAN>	1.00</SPAN>	52%</SPAN>
3</SPAN>	PT</SPAN>	22.00</SPAN>	1.00</SPAN>	5%</SPAN>
	TOTAL</SPAN>	89.58</SPAN>	17.00</SPAN>	19%</SPAN>

<TBODY>
</TBODY>

How would I set up my powerpivot to automatically calculate turnover % (# of terms/headcount) for the total of the sliced data instead of each individual position?

My end result is to have pivot table as below that will change as we slice. In this example though, the organization and dept should equal the same amounts but do not because it the pivot is averaging the turnover % from the original spreadsheet. Any help is greatly appreciated!

	</SPAN> Row Labels Organization Dept Saratoga Benchmark Q1 2013</SPAN> 0.12</SPAN> 0.185958736</SPAN> 0.107</SPAN> Q2 2013</SPAN> 0.112</SPAN> 0.171813548</SPAN> 0.107</SPAN> Q3 2013</SPAN> 0.109</SPAN> 0.137427122</SPAN> 0.107</SPAN> Q4 2013</SPAN> 0.097</SPAN> 0.12040097</SPAN> 0.107</SPAN> Grand Total 0.109531944 0.153523408 0.107 <TBODY> </TBODY>	</SPAN>
	</SPAN>

<TBODY>
</TBODY>