Pivot Chart Connections

[aschaffner]

Hi!

I am doing a project for school, and I have to show multiple different pivot charts, pivot tables, and slicers using the same data set. So far, a have 3 different charts and tables but the 4th is giving me trouble. I have to group dates between 1910 - 2019 by decade, but when I do this on the 4th pivot table, it changes all my other charts and tables. How do I group the data without it changing my other charts and tables? Is there a step-by-step process?

[#2]

@aschaffner The article in the link below will explain the problem and suggest how to resolve it. Basically, you have to create the fourth PT with it's own pivot cache.

https://www.myonlinetraininghub.com/excel-pivot-cache