Code to update Pivot selection based on other Pivot selection

[whahnelt]

Hi,

I already got some help in the pivot forum but it's not working quite yet. And without any coding experience, I need support to finalise...

I have two pivots ("PivotDetails" and "PivotSummary") where I select the year I want to analyse with the help of a slicer. I then need two other pivots ("PivotDetails_PY" and "PivotSummary_PY") to automatically select the previous year.
I have already created a calculation in D2 showing the previous year, so D2 value should be selected as "Year" for "PivotDetails_PY" and "PivotSummary_PY".
The worksheet is called "PIVOT".

I got below code but a) it selects "All" years, not the value from D2 and b) I need to add the "PivotSummary_PY" to do the same.

Maybe one issue is that the years are formatted as text in my incoming report but are a number when calculated in D2??? Unfortunately, I cannot change the incoming report without a bit of time consuming manual effort every week - which I would like to avoid. So if this is an issue, this should ideally be somehow solved in the code as well.

Please Login or Register  to view this content.

Can anyone help?

[PCI]

Can you attach a short Excel sample ???

[whahnelt]

Can you attach a short Excel sample ???

Hi,
Sure, I have made a simplified version. Worksheet and pivot names as well as cell D2 containing the previous year are the same as my original file.
So for the two lower pivots, the year should automtically be put to teh value in D2.
Thanks!!

[whahnelt]

Can you attach a short Excel sample ???

I SOLVED IT!! With a little support from google and other forum entries I managed to understand enough to change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Then copy-pasted the section for teh second pivot - and now it's working, wohoo! :-)

Thanks anyway!!

[PCI]

Thank you for the feed back!!!