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...

excel

Formulas and Functions

Lorenzo
Jun 29, 2023
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)

Lorenzo

Silver Contributor

Jun 29, 2023

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)

labferjane

Copper Contributor

Feb 26, 2024

Thanks Lorenzo . I had a similar question and thanks to you I have solved this issue. It was driving me crazy. Regards

Forum Discussion

How to use GetPivotData on data model Pivot Table