Pivot Table Data

New Contributor



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.


1 Reply
best response confirmed by Daniel_97 (New Contributor)


Change that last part of the formula to: