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