Hi, i've been searching the internet for a possible solution about the getpivotdata function in googlesheet but can't find a working solution.
In this picture, I want to pull a data in a pivot and show in the table below(red circle).
I'm using this formula
=GETPIVOTDATA("Calls",$Q$1,"DATE",$Q46,"Name",$R46)
where $Q$1 is the reference pivot.
$Q46 is the cell that contains the reference date that I want to change everytime.
$R46 is the cell that contains the reference name that I want to change everytime.
My problem is making the cell Q46 as the reference date doesn't work in googlesheets. But its working fine in excel.
I've attached the sample data. Please is there anyone can help me.

In this picture, I want to pull a data in a pivot and show in the table below(red circle).
I'm using this formula
=GETPIVOTDATA("Calls",$Q$1,"DATE",$Q46,"Name",$R46)
where $Q$1 is the reference pivot.
$Q46 is the cell that contains the reference date that I want to change everytime.
$R46 is the cell that contains the reference name that I want to change everytime.
My problem is making the cell Q46 as the reference date doesn't work in googlesheets. But its working fine in excel.
I've attached the sample data. Please is there anyone can help me.
