Grand Total AVERAGE in Pivot Table

[mkereppa]

[TABLE="width: 535"]
<colgroup><col><col><col span="3"></colgroup><tbody>[TR]
[TD]Hi there,

Is there a way to make a pivot table include a Grand Total average? I want to average the totals by fiscal year not average each of the individual entries amounts. The cut and paste of the table is below, along with a handmade column of averages that I want. But I want to be able to include the Average column in pivot charts.





















Sum of Amount[/TD]
[TD]Column Labels[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row Labels[/TD]
[TD="align: right"]2016[/TD]
[TD="align: right"]2017[/TD]
[TD]Grand Total[/TD]
[TD]FY Average[/TD]
[/TR]
[TR]
[TD]Costumes[/TD]
[TD="align: right"]$441,566.35[/TD]
[TD="align: right"]$513,879.94[/TD]
[TD="align: right"]$955,446.29[/TD]
[TD="align: right"]$477,723.15[/TD]
[/TR]
[TR]
[TD]IATSE Carpenters[/TD]
[TD="align: right"]$92,132.37[/TD]
[TD="align: right"]$196,114.04[/TD]
[TD="align: right"]$288,246.41[/TD]
[TD="align: right"]$144,123.21[/TD]
[/TR]
[TR]
[TD]IATSE Stagehands[/TD]
[TD="align: right"]$619,472.62[/TD]
[TD="align: right"]$669,747.54[/TD]
[TD="align: right"]$1,289,220.16[/TD]
[TD="align: right"]$644,610.08[/TD]
[/TR]
[TR]
[TD]Lights[/TD]
[TD="align: right"]$105,502.22[/TD]
[TD="align: right"]$140,349.87[/TD]
[TD="align: right"]$245,852.09[/TD]
[TD="align: right"]$122,926.05[/TD]
[/TR]
[TR]
[TD]Production Education[/TD]
[TD="align: right"]$41,659.46[/TD]
[TD="align: right"]$48,703.84[/TD]
[TD="align: right"]$90,363.30[/TD]
[TD="align: right"]$45,181.65[/TD]
[/TR]
[TR]
[TD]Production Office[/TD]
[TD="align: right"]$150,693.40[/TD]
[TD="align: right"]$272,037.22[/TD]
[TD="align: right"]$422,730.62[/TD]
[TD="align: right"]$211,365.31[/TD]
[/TR]
[TR]
[TD]Properties[/TD]
[TD="align: right"]$252,055.30[/TD]
[TD="align: right"]$278,729.47[/TD]
[TD="align: right"]$530,784.77[/TD]
[TD="align: right"]$265,392.39[/TD]
[/TR]
[TR]
[TD]Scenery[/TD]
[TD="align: right"]$454,097.27[/TD]
[TD="align: right"]$429,579.64[/TD]
[TD="align: right"]$883,676.91[/TD]
[TD="align: right"]$441,838.46[/TD]
[/TR]
[TR]
[TD]Sound[/TD]
[TD="align: right"]$90,959.56[/TD]
[TD="align: right"]$88,490.19[/TD]
[TD="align: right"]$179,449.75[/TD]
[TD="align: right"]$89,724.88[/TD]
[/TR]
[TR]
[TD]Stage Management[/TD]
[TD="align: right"]$302,015.43[/TD]
[TD="align: right"]$40,714.66[/TD]
[TD="align: right"]$342,730.09[/TD]
[TD="align: right"]$171,365.05[/TD]
[/TR]
[TR]
[TD]Video/Projections[/TD]
[TD="align: right"]$11,504.24[/TD]
[TD="align: right"]$16,493.13[/TD]
[TD="align: right"]$27,997.37[/TD]
[TD="align: right"]$13,998.69[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD="align: right"]$2,561,658.22[/TD]
[TD="align: right"]$2,694,839.54[/TD]
[TD="align: right"]$5,256,497.76[/TD]
[TD="align: right"]$2,628,248.88[/TD]
[/TR]
</tbody>[/TABLE]