Pivot Table Grand Total Formulas

wcfreels

New Member
Joined
Jan 27, 2005
Messages
2
Hi-

:rolleyes:

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?

:oops:

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

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,318
Office Version
  1. 365
Platform
  1. Windows
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

New Member
Joined
Jan 27, 2005
Messages
2
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".
 

Forum statistics

Threads
1,147,622
Messages
5,742,199
Members
423,711
Latest member
luisfreitas

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top