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.

Association	2014	2015	2016	2016 Through May	2017 Through May	2017 Commitment or 2016 Total
Black River	23,259	23,058	42,588	11,265	11,281	42,948
Essex	11,429	9,199	11,336	1,190	1,140	11,436
Genesee Valley	88,496	86,325	80,563	22,995	33,184	80,409
Hudson Mohawk	41,169	38,409	35,030	3,611	5,910	35,110
Metro	184,219	165,387	157,352	28,624	29,617	157,720
Oneida	50,177	55,128	48,638	13,983	16,398	46,197
Suffolk	45,446	41,644	41,284	7,325	10,568	41,304
Susquehanna	122,753	121,367	118,267	31,276	31,954	121,006
Western	92,904	96,229	95,015	26,747	24,917	89,340
Subtotal	659,851	636,746	630,073	147,016	164,969	625,470
Miscellaneous Gifts	770	1,402	915	215	255	915
Grand Total	660,621	638,148	630,988	147,231	165,224	626,385

<tbody>
</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...