# 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

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

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

### Similar threads

Replies
0
Views
443
Replies
5
Views
598
Replies
0
Views
385
Replies
2
Views
376
Replies
0
Views
395

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Threads
1,151,608
Messages
5,765,402
Members
425,282
Latest member
Nibblesy

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

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