GETPIVOTDATA #REF! Error even when I have data in the pivot table

[nihad]

Hi all

I'm trying to use GETPIVOTDATA but as you can see I get Ref error

my pivot table is on column V

my formula is

=GETPIVOTDATA("Total",$V$1,"Location",Y3)

01. Development chef recharges STD RECHARGE Feb21.xlsx
	P		R			U	V	W	X	Y	Z
1	Total		Location				Row Labels	Sum of Total		Locations per TA	Sum of Total
2	£76,259.16		105				105	147428.16		103	0
3	£71,169.00		105				106	502392.96		105	#REF!
4	£502,392.96		106				117	136605.72		106	#REF!
monthly budget update

Cell Formulas
Range	Formula
R2:R4	R2	=MID(C2,6,3)
Z2:Z4	Z2	=GETPIVOTDATA("Total",$V$1,"Location",Y2)

 

[RoryA]

Your locations appear to be text, so try:

=GETPIVOTDATA("Total",$V$1,"Location",""&Y3)

 

[nihad]

Your locations appear to be text, so try:

=GETPIVOTDATA("Total",$V$1,"Location",""&Y3)

Oh yes you are right

Thank you so much