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