Reference a dynamic cell in a formula (in a pivot table)

Question

I am trying to reference a cell value in a pivot table as part of a formula outside the table. This table expands and shrinks.

How do I reference the same cell in a pivot table that is not static?

Thank you.

Answer 1

You should use GETPIVOTDATA formula as describe in this link https://support.office.com/en-us/article/GETPIVOTDATA-function-8c083b99-a922-4ca0-af5e-3af55960761f. It allows you to reference the pivot table and locate the data using the field names