Pivot table calculated fields

[Gregorys05]

Hi,
I have a pivot table as per below:

I am trying to get a calculated field the will take the worktype value and devide it by the total for that month:

E.G Worktype1 in Jun-11 would be
uk = 756/756
India = 0/756

So i can change them to percentages so:
uk = 100%
India = 0%

I have tried % of Row but because of there is more than one month this dosen't work..

Any ideas.


<TABLE style="WIDTH: 506pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=674 border=0><COLGROUP><COL style="WIDTH: 82pt; mso-width-source: userset; mso-width-alt: 3986" span=2 width=109><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2779" span=6 width=76><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl77 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 82pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: black" width=109 height=20>Sum of PROC QC</TD><TD class=xl77 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 82pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black" width=109>Month</TD><TD class=xl77 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black" width=76>Uk/india</TD><TD class=xl77 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black" width=76> </TD><TD class=xl77 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black" width=76> </TD><TD class=xl77 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black" width=76> </TD><TD class=xl77 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black" width=76> </TD><TD class=xl77 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 57pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black" width=76> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl77 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: black" height=20> </TD><TD class=xl78 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black" align=right>Jun-11</TD><TD class=xl77 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black"> </TD><TD class=xl78 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black" align=right>Jul-11</TD><TD class=xl77 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black"> </TD><TD class=xl78 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black" align=right>Aug-11</TD><TD class=xl77 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black"> </TD><TD class=xl78 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black">Grand Total</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl77 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: black" height=20>Worktype</TD><TD class=xl77 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black">India</TD><TD class=xl77 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black">UK</TD><TD class=xl77 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black">India</TD><TD class=xl77 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black">UK</TD><TD class=xl77 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black">India</TD><TD class=xl77 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black">UK</TD><TD class=xl77 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: black"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl79 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #d8d8d8 0.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: #f2f2f2" height=20>Type 1</TD><TD class=xl80 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d8d8d8"> </TD><TD class=xl81 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #f2f2f2" align=right>756</TD><TD class=xl80 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d8d8d8"> </TD><TD class=xl81 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #f2f2f2" align=right>756</TD><TD class=xl80 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d8d8d8"> </TD><TD class=xl81 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #f2f2f2" align=right>756</TD><TD class=xl80 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d8d8d8" align=right>2268</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl79 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #d8d8d8 0.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: #f2f2f2" height=20>Type 2</TD><TD class=xl80 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d8d8d8"> </TD><TD class=xl81 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #f2f2f2" align=right>860</TD><TD class=xl80 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d8d8d8"> </TD><TD class=xl81 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #f2f2f2" align=right>860</TD><TD class=xl80 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d8d8d8"> </TD><TD class=xl81 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #f2f2f2" align=right>860</TD><TD class=xl80 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d8d8d8" align=right>2580</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl79 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #d8d8d8 0.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: #f2f2f2" height=20>Type 3</TD><TD class=xl80 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d8d8d8" align=right>738</TD><TD class=xl81 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #f2f2f2" align=right>1117</TD><TD class=xl80 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d8d8d8" align=right>738</TD><TD class=xl81 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #f2f2f2" align=right>1117</TD><TD class=xl80 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d8d8d8" align=right>738</TD><TD class=xl81 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #f2f2f2" align=right>1117</TD><TD class=xl80 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d8d8d8" align=right>5565</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl79 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #d8d8d8 0.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: #f2f2f2" height=20>Type 4</TD><TD class=xl80 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d8d8d8" align=right>976</TD><TD class=xl81 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #f2f2f2" align=right>1841</TD><TD class=xl80 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d8d8d8" align=right>976</TD><TD class=xl81 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #f2f2f2" align=right>1841</TD><TD class=xl80 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d8d8d8" align=right>976</TD><TD class=xl81 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #f2f2f2" align=right>1841</TD><TD class=xl80 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d8d8d8" align=right>8451</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl79 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #d8d8d8 0.5pt solid; BORDER-BOTTOM: #ece9d8; HEIGHT: 15pt; BACKGROUND-COLOR: #f2f2f2" height=20> </TD><TD class=xl80 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d8d8d8"> </TD><TD class=xl81 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #f2f2f2"> </TD><TD class=xl80 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d8d8d8"> </TD><TD class=xl81 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #f2f2f2"> </TD><TD class=xl80 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d8d8d8"> </TD><TD class=xl81 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #f2f2f2"> </TD><TD class=xl80 style="BORDER-RIGHT: #bfbfbf 0.5pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #bfbfbf 0.5pt solid; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #d8d8d8"> </TD></TR></TBODY></TABLE>