Calculated Field in Pivot Table

[kryshawk]

So I have a pivot table that sums how many referral were made in a month for which month. Essentially calculating the number of future referrals. Now I need to create a calculated field in my pivot table that subtracts the referrals made in the same month. Below is what my pivot table looks like. So what I am trying to accomplish in my calculated field is this: Reading vertically (left to right), August had a total of 16 referrals, 11 of them for the month of August, thus I want my calculated field to show 5 as the new total. Any suggestions?

Count of Referral Date	Column Labels
Row Labels	January	February	March	April	May	June	July	August	September	October	November	December
Feb	3
Mar	1	1
Apr			2
May				1	1
Jun
Jul						1
Aug							1	11
Sept								3	3
Oct				1					7
Nov	1	1			1	1	1	2	2	7	4	1
Dec											2	1
Grand Total	5	2	2	2	2	3	2	16	12	7	6	2

<tbody>
</tbody>

 

[snjpverma]

August had a total of 16 referrals ? How ?

 

[kryshawk]

11 referral in August were for the month of August, 3 referrals made in August for the month of Sept, and 2 referrals made for month of November for a total of 16 referrals all together. What I'm trying to not count is the referrals made in the same month for the same month.

 

[snjpverma]

I don't know if you can get that by making changes in the Pivot Table settings. However, you can certainly do this by making a data separately with the help of Formulas and get the desired results