I have a pivot table in which I've created my YoY Change column for the month. I want my pivot table also to display the year over year for the quarter subtotals and year subtotals. Below is a manual approach to getting the display I want, but I hate having to repaste every month. I'd like to add next to the quarter and year subtotal columns additional YoY columns for the % change between Q4 2016 vs. Q4 2017 and 2016 vs. 2017. Is this possible?
[TABLE="width: 793"]
<tbody>[TR]
[TD="colspan: 4, align: center"]DECEMBER[/TD]
[TD="colspan: 3"]Q4 TOTALS[/TD]
[TD="colspan: 3"]YTD TOTALS[/TD]
[/TR]
[TR]
[TD="align: center"]2017[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]2016[/TD]
[TD="align: center"]2017[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]2016[/TD]
[TD="align: center"]2017[/TD]
[TD="align: center"][/TD]
[TD="align: center"]2016[/TD]
[/TR]
[TR]
[TD="align: center"]Total NAP[/TD]
[TD="align: center"]YoY Change[/TD]
[TD="align: center"]Total NAP[/TD]
[TD="align: center"]Total NAP[/TD]
[TD="align: center"]YoY Change[/TD]
[TD="align: center"]Total NAP[/TD]
[TD="align: center"]Total NAP[/TD]
[TD="align: center"]YoY Change[/TD]
[TD="align: center"]Total NAP[/TD]
[/TR]
[TR]
[TD="align: center"]$1,864,378[/TD]
[TD="align: center"]3.5%[/TD]
[TD="align: center"]$1,802,265[/TD]
[TD="align: center"]$4,875,187[/TD]
[TD="align: center"]9.2%[/TD]
[TD="align: center"]$4,464,611[/TD]
[TD="align: center"]$17,288,281[/TD]
[TD="align: center"]12.6%[/TD]
[TD="align: center"]$15,348,524[/TD]
[/TR]
[TR]
[TD="align: center"]$1,161,827[/TD]
[TD="align: center"]-3.5%[/TD]
[TD="align: center"]$1,204,358[/TD]
[TD="align: center"]$3,171,911[/TD]
[TD="align: center"]3.5%[/TD]
[TD="align: center"]$3,064,952[/TD]
[TD="align: center"]$11,179,586[/TD]
[TD="align: center"]6.0%[/TD]
[TD="align: center"]$10,552,150[/TD]
[/TR]
[TR]
[TD="align: center"]$343,127[/TD]
[TD="align: center"]30.6%[/TD]
[TD="align: center"]$262,647[/TD]
[TD="align: center"]$889,118[/TD]
[TD="align: center"]55.7%[/TD]
[TD="align: center"]$570,910[/TD]
[TD="align: center"]$2,899,055[/TD]
[TD="align: center"]27.5%[/TD]
[TD="align: center"]$2,273,223[/TD]
[/TR]
[TR]
[TD="align: center"]$248,139[/TD]
[TD="align: center"]14.2%[/TD]
[TD="align: center"]$217,323[/TD]
[TD="align: center"]$721,147[/TD]
[TD="align: center"]49.3%[/TD]
[TD="align: center"]$483,056[/TD]
[TD="align: center"]$2,035,942[/TD]
[TD="align: center"]36.4%[/TD]
[TD="align: center"]$1,492,648[/TD]
[/TR]
</tbody>[/TABLE]
<tbody>[TR]
[TD="colspan: 4, align: center"]DECEMBER[/TD]
[TD="colspan: 3"]Q4 TOTALS[/TD]
[TD="colspan: 3"]YTD TOTALS[/TD]
[/TR]
[TR]
[TD="align: center"]2017[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]2016[/TD]
[TD="align: center"]2017[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"]2016[/TD]
[TD="align: center"]2017[/TD]
[TD="align: center"][/TD]
[TD="align: center"]2016[/TD]
[/TR]
[TR]
[TD="align: center"]Total NAP[/TD]
[TD="align: center"]YoY Change[/TD]
[TD="align: center"]Total NAP[/TD]
[TD="align: center"]Total NAP[/TD]
[TD="align: center"]YoY Change[/TD]
[TD="align: center"]Total NAP[/TD]
[TD="align: center"]Total NAP[/TD]
[TD="align: center"]YoY Change[/TD]
[TD="align: center"]Total NAP[/TD]
[/TR]
[TR]
[TD="align: center"]$1,864,378[/TD]
[TD="align: center"]3.5%[/TD]
[TD="align: center"]$1,802,265[/TD]
[TD="align: center"]$4,875,187[/TD]
[TD="align: center"]9.2%[/TD]
[TD="align: center"]$4,464,611[/TD]
[TD="align: center"]$17,288,281[/TD]
[TD="align: center"]12.6%[/TD]
[TD="align: center"]$15,348,524[/TD]
[/TR]
[TR]
[TD="align: center"]$1,161,827[/TD]
[TD="align: center"]-3.5%[/TD]
[TD="align: center"]$1,204,358[/TD]
[TD="align: center"]$3,171,911[/TD]
[TD="align: center"]3.5%[/TD]
[TD="align: center"]$3,064,952[/TD]
[TD="align: center"]$11,179,586[/TD]
[TD="align: center"]6.0%[/TD]
[TD="align: center"]$10,552,150[/TD]
[/TR]
[TR]
[TD="align: center"]$343,127[/TD]
[TD="align: center"]30.6%[/TD]
[TD="align: center"]$262,647[/TD]
[TD="align: center"]$889,118[/TD]
[TD="align: center"]55.7%[/TD]
[TD="align: center"]$570,910[/TD]
[TD="align: center"]$2,899,055[/TD]
[TD="align: center"]27.5%[/TD]
[TD="align: center"]$2,273,223[/TD]
[/TR]
[TR]
[TD="align: center"]$248,139[/TD]
[TD="align: center"]14.2%[/TD]
[TD="align: center"]$217,323[/TD]
[TD="align: center"]$721,147[/TD]
[TD="align: center"]49.3%[/TD]
[TD="align: center"]$483,056[/TD]
[TD="align: center"]$2,035,942[/TD]
[TD="align: center"]36.4%[/TD]
[TD="align: center"]$1,492,648[/TD]
[/TR]
</tbody>[/TABLE]