Hazardus
New Member
- Joined
- Jun 27, 2024
- Messages
- 3
- Office Version
- Prefer Not To Say
- Platform
- Windows
Hi, i've been searching the internet 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.
Here is the link of the spreadsheet data im working:
docs.google.com
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.
Here is the link of the spreadsheet data im working:
Copy of Copy of Weekly Report - Client Care
DATA Date,Name,Calls,Emails,Texts,Convo,Calls Missed Non-Zillow, Set Zillow, Held Zillow,Not Held Zillow, Set Non-Zillow, Held Non-Zillow,Not Held Non-Zillow,Pickups,Call attempts,Date,Name,Calls,Emails March 28, 2024,June Dagohoy,357,22,199,23,10,3,2,1,9,6,3,4,6,March 28, 2024,Casey Doane,201,2...
