Pivot Table Calculated FIeld HELP

boldwake

New Member
Joined
Nov 13, 2016
Messages
1
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.

Watch MrExcel Video

Forum statistics

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