wsnyder
Board Regular
- Joined
- Sep 23, 2018
- Messages
- 223
- Office Version
- 365
- Platform
- Windows
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
=
How do I change the string reference "Defect" to a cell reference?
Thanks
-w
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
=
Excel Formula:
=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