Pivot Table Data

[Daniel_97]

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.

[#2 · Accepted solution]

@Daniel_97 

Change that last part of the formula to:

&["&B48&"]")