Calculated Field in Pivot Table

kryshawk

New Member
Joined
Mar 23, 2017
Messages
6
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 DateColumn Labels
Row LabelsJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecember
Feb3
Mar11
Apr2
May11
Jun
Jul1
Aug111
Sept33
Oct17
Nov1111122741
Dec21
Grand Total52222321612762

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

snjpverma

Well-known Member
Joined
Oct 2, 2008
Messages
1,384
Office Version
  1. 2016
Platform
  1. Windows
August had a total of 16 referrals ? How ?
 

kryshawk

New Member
Joined
Mar 23, 2017
Messages
6
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

Well-known Member
Joined
Oct 2, 2008
Messages
1,384
Office Version
  1. 2016
Platform
  1. Windows
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,737
Messages
5,597,824
Members
414,180
Latest member
Sir Khaya

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top