Hello
I link to a pivot table as:
=GETPIVOTDATA("[Measures].[Amount]";$J$87;"[Period].[Period]";"[Period].[Period].&[200904]")
to get data from one pivot field, gathered in the top of my sheet. This should continue for all perids, so that I want the next cell to contain:
=GETPIVOTDATA("[Measures].[Amount]";$J$87;"[Period].[Period]";"[Period].[Period].&[200905]")
Howerver when I drag the field to make it autofill the next field, the same value appears (200904).
I know I can disable the 'Generate pivot data' in the pivot table option bar, however this is not what I want, since new members may be added to my pivot table, and linking relatively disables me from getting the total selected if that happens.
What can I do to resolve this issue?
I'm using office 2003.
Bookmarks