I am trying to find out a way to change the date on an OLAP pivot table by having it reference another cell on another worksheet. Can a GetPivotData function do that? I've been trying to get it to work by putting in the cell that I want it to reference but it keeps coming up with #REF.
=GETPIVOTDATA("[Measures].[Net]",$E$7,"[Reporting Date].[Fiscal Week]","[Reporting Date].[Fiscal Week].&")
Here is my GetPivotData formula. I tried putting the ["&A1&"] in different places in the formula but it won't work.
Any help would be much appreciated.