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 to a #REF error

Here is an example of formulas I’m using, with reference week 42, when changing reference week with the slicer, the table will update, but the formula keeps “[NF].[Week].&[42]” returning the error message?

=GETPIVOTDATA(“[Measures].[Count of Branch 3]”,’PIVOT NF’!$Q$3,”[NF].[Week]”,”[NF].[Week].&[42]”,”[NF].[Dep]”,”[NF].[Dep].&[EXP]”)

How can I ensure that the formula updates along with the table? Am I not using GETPIVOTDATA functions correctly?

​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 to a #REF error Here is an example of formulas I’m using, with reference week 42, when changing reference week with the slicer, the table will update, but the formula keeps “[NF].[Week].&[42]” returning the error message? =GETPIVOTDATA(“[Measures].[Count of Branch 3]”,’PIVOT NF’!$Q$3,”[NF].[Week]”,”[NF].[Week].&[42]”,”[NF].[Dep]”,”[NF].[Dep].&[EXP]”) How can I ensure that the formula updates along with the table? Am I not using GETPIVOTDATA functions correctly?  Read More

​