Pivot Table Grand Total Formulas

[wcfreels]

Hi-



I have a question about a pivot table grand total column. Is there any way of making a formula in the grand total column work instead of summing everything from the amounts to its left?

Scenario:

I've created a pivot table that has Actuals, Budget, Variance Amount, and Variance %.

The Variance % row uses a simple formula I created in "Calculated Item" to calculate a percentage of "Actuals" vs. "Variance".

At the end of the table, I have set the options to give me grand totals for all the amounts across the fiscal months.

The problem is, the percentage also totals everything to the left instead of doing the normal calculation of the amounts above it. Is there a way to make the formula work instead of summing to the left?



Hope this is clear and someone can help. Thank you!

 

[Norie]

Do you really need a calculated item for the Variance %?

Can't you add Actuals again and show it as a % of Variance?

This might help with the grand total problem.

Can you post an example of your raw data and what you want?

Perhaps using Colo's HTML Maker?

 

[wcfreels]

Unfortunately, as this is a weekly auto-generated report I do need the calculation in there (it's for other people; the idea is to show how much they are over or underrunning by percentage).

I tried using Colo's HTML Maker, but I get a referencing error after I click "enable macros".