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