Forum Discussion
Solved
GETPIVOTDATA Dynamic Referencing from Sliced Pivot Table
Hi all, I'm using a Sliced Pivot Table to generate dynamic Charts and only realized after working on the rest of my Workbook that changing the reference week will not update the formula, leading ...
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.
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.
Wonderful! Exactly what I needed, thank you so much!