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|