Hi,
I want to make the "getpivotdata" function dynamic.
It is important to know that I used Power Pivot to create pivot tables.
This is my function: =IFERROR(GETPIVOTDATA("[Measures].["&$D9&"]";'ST Operations'!$A$1;"[T_Calendar].[Year]";"[T_Calendar].[Year].&["&$D$5&"]";"[T_Operations].[Operations]";"[T_Operations].[Operations].&["&$B$8&"]";"[T_Calendar].[MonthNumber]";"[T_Calendar].[MonthNumber].&["&$H$5&"]");"not available")
It is the reference to the pivot table which I want to make dynamic:
'ST Operations'!$A$1
the second pivot table is completely the same, except it has data from YTD and the other pivot table has data from only 1 month.
Can I refer to another pivottable dynamically?
Thanks in advance for your reply.
Best Regards,
Axelle
I want to make the "getpivotdata" function dynamic.
It is important to know that I used Power Pivot to create pivot tables.
This is my function: =IFERROR(GETPIVOTDATA("[Measures].["&$D9&"]";'ST Operations'!$A$1;"[T_Calendar].[Year]";"[T_Calendar].[Year].&["&$D$5&"]";"[T_Operations].[Operations]";"[T_Operations].[Operations].&["&$B$8&"]";"[T_Calendar].[MonthNumber]";"[T_Calendar].[MonthNumber].&["&$H$5&"]");"not available")
It is the reference to the pivot table which I want to make dynamic:
'ST Operations'!$A$1
the second pivot table is completely the same, except it has data from YTD and the other pivot table has data from only 1 month.
Can I refer to another pivottable dynamically?
Thanks in advance for your reply.
Best Regards,
Axelle
