Pivot grand total % calculation

[kumar1803]

I am working on a pivot table to look at data of previous quarter and current quarter. I got a grand total in the bottom for each value. However, when I am putting a formula for % change from previous quarter to current quarter, in the grand total, the % change is not based on total and it is incorrect.

Is there a way for me to fix a formula for % change on grand total?

Total Federal Rebates	$ 900,451	$ 1,324,039	709%	$ 1,473,745	179%	$ 1,057,923	35%	$ 1,417,553	387%	1640%
Total Supplemental Rebate	$ 200,713	$ 373,058		$ 360,611		$ 217,565		$ 215,561
Total Units	$ 54,830	$ 81,367	576%	$ 91,531	66%	$ 53,926	-182%	$ 65,242	210%	599%

<tbody>
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col span="2"></colgroup>

 

[SpillerBD]

It looks you're on the right track. I don't use the additional calculation methods enough so the "Show Value as...Percent of... " Parent? Previous? still has me doing a little trial & verification.
If all else fails you can always add a calculated field or a calculated field directly to your source table.