Forum Discussion
SC713
Jun 29, 2023Copper Contributor
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...
- Jun 30, 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
Jun 30, 2023Silver Contributor
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)
- labferjaneFeb 26, 2024Copper Contributor
Thanks Lorenzo . I had a similar question and thanks to you I have solved this issue. It was driving me crazy. Regards