Hi,
i have several sheets with different pivot tables in it. when i make a dashboard in one sheet i want to be able to copy paste it to different sheets. By changing 1 cell i want the GETPIVOT() formula to fetch data from a different pivot table in a different sheet.
Current formula:
=IFERROR(GETPIVOTDATA("[Measures].[Sales]";ABC!$A$4;"[Product].[Market companies]";"[Product].[Market companies].[Market company].&["&$A3&"]";"[Product].[Products]";"[Product].[Products].[Product].&["&$B3&"]";"[FSTimeCalculation].[Time Calculation]";"[FSTimeCalculation].[Time Calculation].&[P]";"[Current month]";"[Date].[Y-Q-M-D].[Month].&[12]&[2013]");0)
Instead of ABC!$A$4 i want to link to for instance A1 in the worksheet the dashboard is where i can change that cell to DEF.
Any tips? i am currently stuck
i have several sheets with different pivot tables in it. when i make a dashboard in one sheet i want to be able to copy paste it to different sheets. By changing 1 cell i want the GETPIVOT() formula to fetch data from a different pivot table in a different sheet.
Current formula:
=IFERROR(GETPIVOTDATA("[Measures].[Sales]";ABC!$A$4;"[Product].[Market companies]";"[Product].[Market companies].[Market company].&["&$A3&"]";"[Product].[Products]";"[Product].[Products].[Product].&["&$B3&"]";"[FSTimeCalculation].[Time Calculation]";"[FSTimeCalculation].[Time Calculation].&[P]";"[Current month]";"[Date].[Y-Q-M-D].[Month].&[12]&[2013]");0)
Instead of ABC!$A$4 i want to link to for instance A1 in the worksheet the dashboard is where i can change that cell to DEF.
Any tips? i am currently stuck