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?

[TABLE="width: 1077"]
<tbody>[TR]
[TD]Total Federal Rebates[/TD]
[TD] $ 900,451[/TD]
[TD] $ 1,324,039[/TD]
[TD="align: right"]709%[/TD]
[TD] $ 1,473,745[/TD]
[TD="align: right"]179%[/TD]
[TD] $ 1,057,923[/TD]
[TD="align: right"]35%[/TD]
[TD] $ 1,417,553[/TD]
[TD="align: right"]387%[/TD]
[TD="align: right"]1640%[/TD]
[/TR]
[TR]
[TD]Total Supplemental Rebate[/TD]
[TD] $ 200,713[/TD]
[TD] $ 373,058[/TD]
[TD] [/TD]
[TD] $ 360,611[/TD]
[TD] [/TD]
[TD] $ 217,565[/TD]
[TD] [/TD]
[TD] $ 215,561[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Total Units[/TD]
[TD] $ 54,830[/TD]
[TD] $ 81,367[/TD]
[TD="align: right"]576%[/TD]
[TD] $ 91,531[/TD]
[TD="align: right"]66%[/TD]
[TD] $ 53,926[/TD]
[TD="align: right"]-182%[/TD]
[TD] $ 65,242[/TD]
[TD="align: right"]210%[/TD]
[TD="align: right"]599%[/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col span="2"></colgroup>[/TABLE]

 

[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.