GET PIVOTDATA #REF! - Error

[tomlinsn]

I want to use the GET PIVOTDATA function to reference data fromwithin a Pivotable. When I enter: =GETPIVOTDATA("Amount",'2019'!$R$4,"Fund","1100","Orgn","2002","Acct","5815"),I get the result of $15,589.15

I want the function to be dynamic and retrieve the informationdisplayed in the Acct field stored in cell T8 in the Pivot Table. When Ichange the function to =GETPIVOTDATA("Amount",'2019'!$R$4,"Fund","1100","Orgn","2002","Acct",T8)I get #REF!

What am I doing wrong? How do I fix this to keep it dynamic?

Thank you in advance for your help,
Tom

 

[FormR]

Hi, does this small amendment help?

=GETPIVOTDATA("Amount",'2019'!$R$4,"Fund","1100","Orgn","2002","Acct",T8&"")

 

[tomlinsn]

Hi - It does!! Perfect!! Now, please tell me why this works. I understand the & concatenate function, but I don't understand how the syntax of this work. Obviously needs 5815 inside the "".

Thank you so much!!

 

[FormR]

Hi, your value in T8 is a number, and the data in your pivot table is text. Appending a zero length string the number changes it to a text value.