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?

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>

 

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