# Pivot Table Grand Total Formulas

#### wcfreels

##### New Member
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!

### 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
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
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".

Replies
2
Views
310
Replies
0
Views
303
Replies
0
Views
298
Replies
1
Views
93
Replies
0
Views
275

1,181,748
Messages
5,931,792
Members
436,805
Latest member
waseem abbas

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

### Which adblocker are you using?

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

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