Referencing within a GetPivotData function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael - 21 Jun 2007 16:53 GMT

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.

Reply to this Message

Bernie Deitrick - 21 Jun 2007 17:26 GMT

Did you try:

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

HTH,
Bernie
MS Excel MVP

>I am having issues refrencing cells within a the function.
>
[quoted text clipped - 12 lines]
>
> Thanks for any help with this.

Reply to this Message

Michael - 21 Jun 2007 17:36 GMT

Thanks, I though I would have to use INDIRECT in some way.

> Did you try:
>
[quoted text clipped - 22 lines]
> >
> > Thanks for any help with this.

Reply to this Message