I have the following formula:
But here is my problem. Instead of the last item being [TO], I want it to refer to a cell, A13. How to I adjust the formula to look at a cell reference instead of a specific value. That way whenever the value in A13 changes, the formula results auto updates.
Secondly, is there a way to use a formula similar to the one above but instead of changing [TO] to a single cell reference, change it so that it looks at multiple cell references and performs more like a sum function on the pivot table. (so you'd basically be asking the pivot table to give you a sum based on values in multiple cells)
thanks in advance.
Code:
=GETPIVOTDATA("[Measures].[Agency Amt]",'DATA '!$A$3,"[Time].[Calendar]","[Time].[Calendar].[Year].&[2011].&[1]","[Major Line].[Consolidated Major Lines]","[Major Line].[Consolidated Major Lines].[Major Line Group Description].&[Commercial]","[New Renew].[New Ren]","[New Renew].[New Ren].&[1]","[Staff].[Staff Code]","[Staff].[Staff Code].&[TO]")But here is my problem. Instead of the last item being [TO], I want it to refer to a cell, A13. How to I adjust the formula to look at a cell reference instead of a specific value. That way whenever the value in A13 changes, the formula results auto updates.
Secondly, is there a way to use a formula similar to the one above but instead of changing [TO] to a single cell reference, change it so that it looks at multiple cell references and performs more like a sum function on the pivot table. (so you'd basically be asking the pivot table to give you a sum based on values in multiple cells)
thanks in advance.
