GetPivotData with OLAP(?) Data Connection

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!

Hi rorya,
That worked - thank you. I actually tried this method before posting, but it wasn't working at the time - which made me question whether it worked with OLAP pivots. It turns out that I had broken my pivot connection which is why GETPIVOTDATA didn't work.

For sake of convenience for others searching, GETPIVOTDATA syntax with OLAP does differ a bit in that it appears to use an in-built "Measures" class and an object link to the table:

Formula:

Please Login or Register  to view this content.

My pivot has a "Grand Total" row at bottom, but the reference to "[Measures]" is apparently invoking a method of the table object. Now I'm curious what other methods might be available to GETPIVOTDATA in this manner.