Pivot data #REF error

[Legacy 332503]

I'm currently pulling information from a pivot table using the following formula

=GETPIVOTDATA("Account",'Debt Free'!$C$3,"Centre name","Charlestown","closedmonth","1","closedyear","2015")

However I wish to change this to the following where the location is based upon two other cells

=GETPIVOTDATA("Account",'Debt Free'!$C$3,"Centre name",$F$2,"closedmonth","1","closedyear",$P$1)

However this time it returns a #REF, the error is with the last item $P$1. I believe their is a formatting issue when the table is generated but I cannot find it.

$P$1 contains 2015, but returns a #ref every time.
$F$2 works fine

 

[konew1]

Try putting a complete 2015 date into $P$1.