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

[rheimbro]

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?

[TABLE="width: 298"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]

POID Count[/TD]
[TD] Orders with Cost Increase[/TD]
[TD]Average of POID Totals[/TD]
[/TR]
[TR]
[TD="align: right"]469[/TD]
[TD="align: right"]334[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]436[/TD]
[TD="align: right"]111[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]1234[/TD]
[TD="align: right"]107[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]155[/TD]
[TD="align: right"]106[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]145[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]83[/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]322[/TD]
[TD="align: right"]49[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]359[/TD]
[TD="align: right"]48[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]107[/TD]
[TD="align: right"]48[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]58[/TD]
[TD="align: right"]41[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]167[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]65[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]68[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]59[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]49[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]62[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]70[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]56[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]24[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]17[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]11[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]20[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]4097[/TD]
[/TR]
[TR]
[TD="align: right"]4097[/TD]
[TD="align: right"]1172[/TD]
[TD="align: right"]4097[/TD]
[/TR]
</tbody>[/TABLE]

 

[rheimbro]

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.