Divide one column by another column in a pivot table

[queenbean84]

I have the following information in a pivot table. I want to divide '2017 Through May' by '2017 Commitment or 2016 Total' for each row and have the information in a new column titled '% of Giving'. I have tried several different calculated fields but they all sum! How do I accomplish this? I am using Excel 2010.

<tbody>
[TD="class: xl72"]Association[/TD]
[TD="class: xl70, width: 77"]2014[/TD]
[TD="class: xl70, width: 77"]2015[/TD]
[TD="class: xl70, width: 77"]2016[/TD]
[TD="class: xl70, width: 115"]2016 Through May[/TD]
[TD="class: xl70, width: 115"]2017 Through May[/TD]
[TD="class: xl70, width: 147"]2017 Commitment or 2016 Total[/TD]

[TD="class: xl69"]Black River[/TD]
[TD="class: xl71"] 23,259[/TD]
[TD="class: xl71"] 23,058[/TD]
[TD="class: xl71"] 42,588[/TD]
[TD="class: xl71"] 11,265[/TD]
[TD="class: xl71"] 11,281[/TD]
[TD="class: xl71"] 42,948[/TD]

[TD="class: xl69"]Essex[/TD]
[TD="class: xl71"] 11,429[/TD]
[TD="class: xl71"] 9,199[/TD]
[TD="class: xl71"] 11,336[/TD]
[TD="class: xl71"] 1,190[/TD]
[TD="class: xl71"] 1,140[/TD]
[TD="class: xl71"] 11,436[/TD]

[TD="class: xl69"]Genesee Valley[/TD]
[TD="class: xl71"] 88,496[/TD]
[TD="class: xl71"] 86,325[/TD]
[TD="class: xl71"] 80,563[/TD]
[TD="class: xl71"] 22,995[/TD]
[TD="class: xl71"] 33,184[/TD]
[TD="class: xl71"] 80,409[/TD]

[TD="class: xl69"]Hudson Mohawk[/TD]
[TD="class: xl71"] 41,169[/TD]
[TD="class: xl71"] 38,409[/TD]
[TD="class: xl71"] 35,030[/TD]
[TD="class: xl71"] 3,611[/TD]
[TD="class: xl71"] 5,910[/TD]
[TD="class: xl71"] 35,110[/TD]

[TD="class: xl69"]Metro[/TD]
[TD="class: xl71"] 184,219[/TD]
[TD="class: xl71"] 165,387[/TD]
[TD="class: xl71"] 157,352[/TD]
[TD="class: xl71"] 28,624[/TD]
[TD="class: xl71"] 29,617[/TD]
[TD="class: xl71"] 157,720[/TD]

[TD="class: xl69"]Oneida[/TD]
[TD="class: xl71"] 50,177[/TD]
[TD="class: xl71"] 55,128[/TD]
[TD="class: xl71"] 48,638[/TD]
[TD="class: xl71"] 13,983[/TD]
[TD="class: xl71"] 16,398[/TD]
[TD="class: xl71"] 46,197[/TD]

[TD="class: xl69"]Suffolk[/TD]
[TD="class: xl71"] 45,446[/TD]
[TD="class: xl71"] 41,644[/TD]
[TD="class: xl71"] 41,284[/TD]
[TD="class: xl71"] 7,325[/TD]
[TD="class: xl71"] 10,568[/TD]
[TD="class: xl71"] 41,304[/TD]

[TD="class: xl69"]Susquehanna[/TD]
[TD="class: xl71"] 122,753[/TD]
[TD="class: xl71"] 121,367[/TD]
[TD="class: xl71"] 118,267[/TD]
[TD="class: xl71"] 31,276[/TD]
[TD="class: xl71"] 31,954[/TD]
[TD="class: xl71"] 121,006[/TD]

[TD="class: xl69"]Western[/TD]
[TD="class: xl71"] 92,904[/TD]
[TD="class: xl71"] 96,229[/TD]
[TD="class: xl71"] 95,015[/TD]
[TD="class: xl71"] 26,747[/TD]
[TD="class: xl71"] 24,917[/TD]
[TD="class: xl71"] 89,340[/TD]

[TD="class: xl68"]Subtotal[/TD]
[TD="class: xl71"] 659,851[/TD]
[TD="class: xl71"] 636,746[/TD]
[TD="class: xl71"] 630,073[/TD]
[TD="class: xl71"] 147,016[/TD]
[TD="class: xl71"] 164,969[/TD]
[TD="class: xl71"] 625,470[/TD]

[TD="class: xl69"]Miscellaneous Gifts[/TD]
[TD="class: xl71"] 770[/TD]
[TD="class: xl71"] 1,402[/TD]
[TD="class: xl71"] 915[/TD]
[TD="class: xl71"] 215[/TD]
[TD="class: xl71"] 255[/TD]
[TD="class: xl71"] 915[/TD]

[TD="class: xl68"]Grand Total[/TD]
[TD="class: xl71"] 660,621[/TD]
[TD="class: xl71"] 638,148[/TD]
[TD="class: xl71"] 630,988[/TD]
[TD="class: xl71"] 147,231[/TD]
[TD="class: xl71"] 165,224[/TD]
[TD="class: xl71"] 626,385[/TD]

</tbody>

 

[Chrisdontm]

Assuming your Table starts in: "A1"
Go to the far right to the first blank column,
On the header row, title it what you want to call it, like "Percent", or "%"
Then click in the first cell under the new title and type an equals sign,
then click in the first cell under the title; "2017 Through May"
and then type the divided by sign: "/"
Then click in the first cell under the title: "2017 Commitment or 2016 Total"
and hit enter.
You may have to format that range, if so then highlight all the cells under your new title and click the "%" sign button at the top middle in the "Home" tab.
That should do it if I understand you correctly...