GETPIVOTDATA() with relative reference

[Guest]

Hi,

Is there a way of cheating GETPIVOTDATA() into using a cell reference as the
data field argument? As in =GETPIVOTDATA(J8;$A$7;"Rep";$J$9:$L$9). I've tried
with just about every function I can think to get the text from J8 used in
the formula instead of having to write the text.

Any hints?

/Sune

 

[Guest]

Is there a way of cheating GETPIVOTDATA() into using a cell reference as the
data field argument? As in =GETPIVOTDATA(J8;$A$7;"Rep";$J$9:$L$9). I've tried
with just about every function I can think to get the text from J8 used in
the formula instead of having to write the text.

The T function seems to work ok when I tested it lightly,
so we could try: =GETPIVOTDATA(T(J8);$A$7;"Rep";$J$9:$L$9).

---

 

[Guest]

The T function seems to work ok when I tested it lightly,

Obviously!! That's exactly what, I was looking for!

Thank you.

/Sune

 

[Guest]

The T function seems to work ok when I tested it lightly,

Obviously! That was exactly what, I was looking for.

Thank you.

/Sune

 

[Guest]

Glad to hear that !
Thanks for the feedback ..

---

 

[Roger The Rabbit]

Hi

Thank you Max the T() Function Worked like a Charm to the same query I
posted earlier on this morning, and found the solution on this query.

Thanks

Roger Ramseier

 

[Guest]

Glad it fit the bill for you too, Roger ! Cheers.