Googlesheet GETPIVOTDATA Function using Date as reference in another cell

Question

In googlesheet i'm getting a "field combination not found" error when using the function GETPIVOTDATA. I'm getting the error when using another cell as a reference date.

This is the formula I'm using:

=GETPIVOTDATA("Calls",$Q$1,"Date",Q46,"Name",R46)

wherein: $Q$1 is the cell containing the reference pivot. Q46 is the cell containing a valid date. R46 is the cell containing the reference Name. Please see image below...

here is the scrnshot

https://docs.google.com/spreadsheets/d/1plMbUhSQkyt7x06VigJadbxd3mLx2gBPyMUS3K7OhjE/edit?usp=sharing

What i'm trying to do is pull the data in the pivot and display it into another table by changing the value in the cell "Q46" (reference date) and "R46" (referance name).

Answer 1

You may try:

=getpivotdata(S$45,$Q$1,"Date",text($Q46,"mmmm d, yyyy"),"Name",$R46)