I am having issues refrencing cells within a the function.

If J1 holds the text "April", I am using:

=GETPIVOTDATA("[Measures].[Hours Worked]",'Project RMT data'!$A$4,"[Project
Text RMT]","[Project Text RMT].[All Project Text
RMT].[Frontier]",INDIRECT("[Time]","[Time].[All Years].[2007].[Q2].["&J1&"]"))

which is returning #VALUE!

however, when I use the same formula ending with ]","[Time].[All
Years].[2007].[Q2].[April]"

the call works correctly.

Thanks for any help with this.