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

rheimbro

New Member
Joined
May 2, 2018
Messages
2
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 IncreaseAverage of POID Totals
4693344097
4361114097
12341074097
1551064097
145844097
83734097
322494097
359484097
107484097
58414097
167304097
65204097
68194097
59164097
49164097
62154097
70114097
5694097
2474097
1774097
2064097
1164097
1034097
1124097
514097
114097
214097
214097
2004097
904097
104097
409711724097

<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
Joined
May 2, 2018
Messages
2
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.
 
Master Excel Bundle

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

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