Nov 27 2023 07:47 PM
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?
Nov 27 2023 10:52 PM
@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.