Pivot table issues where it is linked to a dynamic dataset and the columns sometimes expand

Question

I have made a workflow where I import a large excel table and then basically all 50 pivot tables connected to it change based off this data. I’ve made ‘summary tables’ that reference this.

The issue I am having is with the pivot tables. The ‘columns’ of the pivot table, displays the ‘date’ column. I am only interested in the year of that provided.

Initially I had displayed ‘years,’ then ‘quarters’ then ‘date’ on the ‘columns’ in each pivot table. Whenever I run this, sometimes the pivot tables expand… sometimes the ‘years’ column disappears and I’m only left with the date. Is there anything I can do to avoid it expanding and doing this.

From these tables I just need the ‘years’ to be displayed. However as you would know, I can’t just display the ‘years’ field, I need to have ‘date’ too… I would have preferred to have just had one ‘field’ in the column, as this would have avoided all this trouble. But I cannot seem to get around this.