How to translate a getpivotdata formula into a cell reference
 

Hi all,

I want to be able to get the cell reference (in the format A1) of a
GETPIVOTDATA reference. For example:

=(GETPIVOTDATA("Sum of Qty",'$A$5,"Customer Name","ABC Company"))

pulls data from a corresponding cell in the table. That reference is A10 but
I want to get this from the actual GETPIVOTDATA reference itself. Is this
possible?

Regards

Morgan