Hi,
Let's say I am trying to create a chart from employee data to find out the number of years employees have been in an organisation.
I am looking at 2 different groupings for the # of years spent
1) group by 1 year interval
2) group by 5 years interval
It does not matter how I create the pivot table and charts, when I create the second pivot table and chart the first table and chart default to the group settings of the second chart or vice-versa.
How I avoid that and have 2 separate groups/ views?
Thank you!
From what I understand, you need to un-share the Pivot Cache for both pivot tables. It is explained in this blog post by Mynda:
Excel Pivot Cache • My Online Training Hub
You need to intentionally duplicate Pivot Caches so that you can apply different groupings in pivot tables that use the same data.
It's about 4 minutes into the video.
Thank you! That worked. I was able to duplicate the pivot cache 🙂
However Alt + D + P did not invoke the pivot wizard for me ( I use Excel 2019 on windows 11).
Quick Access Toolbar > More Commands > All Commands and added the Pivot table and Pivot chart wizard to the QAT.
