Forum Discussion
How to use GetPivotData on data model Pivot Table
Hello, I am having a hard time using GetPivotData on my pivot table. I've followed online guides. The difference between my pivot table may be that the original tables are added to data model (so...
Hi SC713
That should be:
=GETPIVOTDATA( "[Measures].[Median UT]",$A$3, "[BatchTensileData].[Work Order-Batch #]", "[BatchTensileData].[Work Order-Batch #].&[" & M4 & "]" )Carefully look at how the concatenation is constructed to "encapsulate" the value of cell M4 between the last brackets
(If you would use CUBEVALUE this would be the same syntax)
As a side note in case you're not aware. GETPIVOTDATA retrieves values that display on a PivotTable, couple of examples below:
In F3 & G3 we want the Total Value for Product A. It doesn't display on the PivotTable ==> #REF with GETPIVOTDATA. On the other hand we get it with CUBEVALUE
In F6 & G6 we want the Total Value for Product A and Date = Jun 1, 2023, no problem. However if we collapse Jun in the PivotTable:
Corresponding sample attached
