I would like to link cells in one table of my workbook to a pivot table on another tab.
If I click on a certain cell, I get this formula: (History_AWM is the name of the tab with the pivot table.)
=GETPIVOTDATA("[Measures].[Sum of Net_Flows]",History_AWM!$A$3,"[Range 1].[Year]","[Range 1].[Year].&[2018]","[Range 1].[Quarter]","[Range 1].[Quarter].&[Qtr 2]")
Instead of the 2018 & Qtr2 values being hard-coded in the formula, is it possible to have then refer to cells in the tab. This would allow me to copy the formula from column to column (or row to row) and use relative references.
Thanks.
Bookmarks