User Profile
Daniel_97
Copper Contributor
Joined Mar 09, 2023
User Widgets
Recent Discussions
Pivot Table Data
Hi, I am trying to extract data dynamically from my pivot table. I have added new measure to the pivot table as my data are all text. However, when I try to link the getpivotdata function to a reference cell, it does not work. It does work when I change the text in the formula manually. Below is a screenshot of the pivot table. When I change the text (Advanced Manufacturing Technology) to (Advanced Materials) manually, the correct KPIs are shown. To link the formula to the reference cell B48, I tried changing the text to (""&B48), but #REF! error is shown. Any idea how to solve this? Thank you in advance.
