GetPivotData Reference With Data Model

[wsnyder]

Hi all,

I'm no good at editing the GetPivotData() Formula when using the Data Model

Here's is what I get when I click = and click on a cell in the Pivot Table
=

=GETPIVOTDATA("[Measures].[Distinct Count of Work_Order]",$A$3,"[Range].[MyData]","[Range].[MyData].&[Defect]")

How do I change the string reference "Defect" to a cell reference?

Thanks
-w

 

[GraH]

Please try

   =GETPIVOTDATA("[Measures].[Distinct Count of Work_Order]",$A$3,"[Range].[MyData]","[Range].[MyData].&["&CellRef&"]")