# Pivot Table - Calculate values as a % of grand total from a different column

#### rheimbro

##### New Member
I have tried a mix of calculated fields, and variations on showing values as % of rows/columns etc and cannot come up with a working solution.

I would like to have a column that takes the "Orders with Cost increase" and shows it as a % of the grand total of the "POID count"

For the first row that would be 334/4097 to come up with 8.1%

I also added a column in the original data has a getpivot data formula so that it always grabs the 4097 in the grand total of that first column, and then when adding it to the pivot table show it as an average instead of summing 4097 many times over. I have called it the appropriate "Average of POID totals" until I can get it to really do anything useful.

Is there a different approach to this that I am not thinking of? Is there some way to do this as a calculated field, or should I just cut my losses and paste the pivot table as values elsewhere and use normal formulas since that is easy enough?

 POID Count Orders with Cost Increase Average of POID Totals 469 334 4097 436 111 4097 1234 107 4097 155 106 4097 145 84 4097 83 73 4097 322 49 4097 359 48 4097 107 48 4097 58 41 4097 167 30 4097 65 20 4097 68 19 4097 59 16 4097 49 16 4097 62 15 4097 70 11 4097 56 9 4097 24 7 4097 17 7 4097 20 6 4097 11 6 4097 10 3 4097 11 2 4097 5 1 4097 1 1 4097 2 1 4097 2 1 4097 20 0 4097 9 0 4097 1 0 4097 4097 1172 4097

<colgroup><col><col><col></colgroup><tbody>
</tbody>

### Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

#### rheimbro

##### New Member
Also- there are a few filters being applied, and will affect the totals, so I cannot just use 4097 as part of the calculated field itself, because it will change in a different scenarios.

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

### Forum statistics

1,167,065
Messages
5,851,875
Members
431,470
Latest member
mikaelaleksandrowicz

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