Excel Pivot Automatically includes Quarter

I can only guess that Excel manage a list of "interresting fields" internally and offer them for display.

Column G in 4 worksheets have circular references.
for instance PREM USD'!$G$6   has formula =ROUND(E6*D6*(1-G6),2)
Try fixing those and see if things work better.

You are seeing the results of using Pivot Table Grouping.  Hold on about 15 minutes while I make a good example for you.

To see how Pivot table Grouping can implement calendar quarters, do the following.

1. Open the Pivit-1 v2 NO QUARTERS.xls.
2.  Alt N V T {enter} to start a new pivot table.
3. Add Date, To, Total GBP
4. Select cell with 1/10/2020
5. Click on  pivot table tools "Options"  tab
6. In the ribbon  take "Group Selection"
7. Select Months Quarters and Years then click OK.

 

1. The pivot table fields list will now have virtual fields like "Quarters". You can then deselect fields you do not want until it looks like this.

 
The new virtual fields will remain associated with the Data Source and new Pivot tables will reflect automatically show them.
But, if you delete all associated pivot tables, the virtual fields are gone and you have to rebuild them.
 
 
 

One last point. You might have several pivot tables associated with the same data source.
When you use Group Selection to modify the Grouping
of one pivot table from Months,Quarters, Year
to become Days, Quarters, Years

Then ALL the associated pivot tables will change. 

It is possible to prevent this by assigning each pivot table to its own pivot cache, but that is a subject for a future question.

Another way is to name your data source "MySource" then create an Alias called "MySource2" which points to the same data, and base each Pivot table on a unique alias.

thanks very much Robert