I have inserted a sample workbook with pivot tables and a line chart. What I would like to know is how could I get the second chart to show 2 year data based on my slicer selection. If I select 2021, as shown, I would want on the second pivot table to show me 2020 and 2021 data. I'm using it to calculate year over year averages. The first pivot table has to work correctly on single year data. I'm controlling multiple charts on a dashboard with the same slicers, and I'm stuck with this issue.
Also how could I see the 2 years displayed on the pivot chart legend. I'm not sure if I have my 2nd pivot table set up correctly. Any help would be appreciated. Thanks
Pivot Charts.xlsx
Also how could I see the 2 years displayed on the pivot chart legend. I'm not sure if I have my 2nd pivot table set up correctly. Any help would be appreciated. Thanks
Pivot Charts.xlsx
