Forum Discussion
GETPIVOTDATA Dynamic Referencing from Sliced Pivot Table
I mocked-up a simplified model to demonstrate a possible solution.
Include the week number (sliced) in the filter area of the pivot table so that you can reference it in the GETPIVOTDATA function
The key is in the part where you replace .[WEEK].&[42]" by .[WEEK].&[" & C3 & "]"
See attached.
Did something similar for a friend of mine a few weeks ago
Just put together a version for 2021. Can't test but should do it...
You are variant is more advanced
It's just that I spent a couple of hours on this. Yours is straightforward and most probably enough for usual scenarios. BTW do you have an opportunity/installation to check the 2021 version?
(I like the simplicity of Riny_van_Eekelen option)
Nope, I don't have 2021, only 365
Thanks anyway SergeiBaklan