Hi,
New here. To increase performance and reduce document size, I rebuilt my sales forecast pivot with Get-And-Transform - which allowed me to load my source data through a query instead of a tab in the document.

For the most part it worked great - the document is about 1/10th original size, loads/saves much faster, and the new pivot still works. However, I was using GETPIVOTDATA to show a grand total in a cell above my pivot and am now getting #REF error there. My syntax is the same as that of previous documents (=GETPIVOTDATA("Grand Total",T37 ) - but I suspect that this no longer works with a pivot based on an query for a data source. (I couldn't determine if mine would be classified as an OLAP query).

Is there a GETPIVOTDATA syntax which will work with a table using a "query" data source rather than conventionally loaded data in another tab?

Any help greatly appreciated!