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.