Forum Discussion
Solved
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)
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)
Thanks Lorenzo . I had a similar question and thanks to you I have solved this issue. It was driving me crazy. Regards
