View Single Post
  #1   Report Post  
Tomas
 
Posts: n/a
Default Data_field parameter in getpivotdtata as a cell reference.


Please can someone help me?

I would like to use parameter data_field as cell reference in getpivotdata
function?
Is it possible and if yes so plesae how?

I tried it several times but result is still #REF!.

Example: =GETPIVOTDATA(B4;$A$3;"Partner";"ABC")

There goes about the B4 parameter because if I rewrite value from cell B4 as
a text then it returns right data.

Thanks in advance