Pivot Table Subtotal on Grouped Data

[cseguin1]

Hi all,

I have a pivot table where I've got row labels listed as Assessor Name, Fiscal Year, and Quarters. I've collapsed Quarters into Fiscal year so all that appears is as below. What I need to represent in red below is what percentage of the total of FY1314 does the blue figure represent. i.e. 129/257 =
50.19% of the total of that fiscal year. I thought to have the fiscal years subtotal and then set the percent to calculate the % of that subtotal but I can't seem to figure out how to do that. How do you subtotal grouped data within a pivot table? Or am I making this more complicated than necessary and there's another way? Any help would be greatly appreciated.

[TABLE="width: 640"]
<TBODY>[TR]
[TD][/TD]
[TD]Location 1</SPAN></SPAN>
[/TD]
[TD]
[/TD]
[TD]Location 2</SPAN></SPAN>
[/TD]
[TD]
[/TD]
[TD]Location 3</SPAN></SPAN>
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]Row Labels</SPAN></SPAN>
[/TD]
[TD]Total Jobs</SPAN></SPAN>
[/TD]
[TD]% of Total Jobs</SPAN></SPAN>
[/TD]
[TD]Total Jobs</SPAN></SPAN>
[/TD]
[TD]% of Total Jobs</SPAN></SPAN>
[/TD]
[TD]Total Jobs</SPAN></SPAN>
[/TD]
[TD]% of Total Jobs</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Assessor Name</SPAN></SPAN>
[/TD]
[TD]209</SPAN></SPAN>
[/TD]
[TD]0.54%</SPAN></SPAN>
[/TD]
[TD]90</SPAN></SPAN>
[/TD]
[TD]0.23%</SPAN></SPAN>
[/TD]
[TD]4017</SPAN></SPAN>
[/TD]
[TD]10.38%</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]FY 1314</SPAN></SPAN>
[/TD]
[TD]129</SPAN></SPAN>
[/TD]
[TD]0.33%</SPAN></SPAN>
[/TD]
[TD]49</SPAN></SPAN>
[/TD]
[TD]0.13%</SPAN></SPAN>
[/TD]
[TD]1636</SPAN></SPAN>
[/TD]
[TD]4.23%</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]FY 1415</SPAN></SPAN>
[/TD]
[TD]80</SPAN></SPAN>
[/TD]
[TD]0.21%</SPAN></SPAN>
[/TD]
[TD]41</SPAN></SPAN>
[/TD]
[TD]0.11%</SPAN></SPAN>
[/TD]
[TD]2381</SPAN></SPAN>
[/TD]
[TD]6.15%</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Assessor Name 2</SPAN></SPAN>
[/TD]
[TD]203</SPAN></SPAN>
[/TD]
[TD]0.52%</SPAN></SPAN>
[/TD]
[TD]108</SPAN></SPAN>
[/TD]
[TD]0.28%</SPAN></SPAN>
[/TD]
[TD]2614</SPAN></SPAN>
[/TD]
[TD]6.76%</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]FY 1314</SPAN></SPAN>
[/TD]
[TD]70</SPAN></SPAN>
[/TD]
[TD]0.18%</SPAN></SPAN>
[/TD]
[TD]41</SPAN></SPAN>
[/TD]
[TD]0.11%</SPAN></SPAN>
[/TD]
[TD]1467</SPAN></SPAN>
[/TD]
[TD]3.79%</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]FY 1415</SPAN></SPAN>
[/TD]
[TD]133</SPAN></SPAN>
[/TD]
[TD]0.34%</SPAN></SPAN>
[/TD]
[TD]67</SPAN></SPAN>
[/TD]
[TD]0.17%</SPAN></SPAN>
[/TD]
[TD]1147</SPAN></SPAN>
[/TD]
[TD]2.96%</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]Assessor Name 3</SPAN></SPAN>
[/TD]
[TD]178</SPAN></SPAN>
[/TD]
[TD]0.46%</SPAN></SPAN>
[/TD]
[TD]62</SPAN></SPAN>
[/TD]
[TD]0.16%</SPAN></SPAN>
[/TD]
[TD]6</SPAN></SPAN>
[/TD]
[TD]0.02%</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]FY 1314</SPAN></SPAN>
[/TD]
[TD]58</SPAN></SPAN>
[/TD]
[TD]0.15%</SPAN></SPAN>
[/TD]
[TD]9</SPAN></SPAN>
[/TD]
[TD]0.02%</SPAN></SPAN>
[/TD]
[TD]3</SPAN></SPAN>
[/TD]
[TD]0.01%</SPAN></SPAN>
[/TD]
[/TR]
[TR]
[TD]FY 1415</SPAN></SPAN>
[/TD]
[TD]120</SPAN></SPAN>
[/TD]
[TD]0.31%</SPAN></SPAN>
[/TD]
[TD]53</SPAN></SPAN>
[/TD]
[TD]0.14%</SPAN></SPAN>
[/TD]
[TD]3</SPAN></SPAN>
[/TD]
[TD]0.01%</SPAN></SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]