# Pivot Table Calculated FIeld HELP

#### boldwake

##### New Member
All,

I just joined this forum so sorry if this is not posted in the right place. First of all while i just joined I've used this form for years to find answers to questions in excel so i'd like to give you an overdue thank you. I have finally come across a problem that I can not solve by just searching mrexcel.com or google.com. I'm tryng to create a calculated field that calculates the contribution to change of a single row, which means i need the calculated field to use the grand total for the calculation.

I can get around this by hardcoding in the grand total from that column but that is clearly not very dynamic. I don't know how to upload / data to this so i'll try to explain it best i can below:

Column 1: 2016 sales by brand
Column 2: 2015 sales by brand

Calculated field: Contribution to the 2016 growth associated with each brand to the total growth in 2016

Formula =(2016 sales - 2015 sales for Brand A)/GRAND TOTAL of 2015 Sales

I have hardcoded in the 2015 sales figure for now but would really like to figure out how i can make the calculated field use the grand total of 2015 sales rather than the "row" total of 2015 sales

Thank you!

### Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Replies
5
Views
276
Replies
4
Views
149
Replies
0
Views
62
Replies
0
Views
209
Replies
1
Views
330

1,129,430
Messages
5,636,232
Members
416,909
Latest member
hayleyg123

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