Pivot- Referencing a cell when the columns and rows change after filtering

[Mysstownsend]

I have a worksheet, where I'd like to have the Average for all months selected to display in Cell c5. The problem is if more than one person is selected the row and column that holds the data shifts.
For example for Wonder Woman, she has an average in April of 6.92. This displays in D8. But if I add Clark Kent the total average doesn't change to show their combined, still only what's in D8. How can I get a consistent reference?
I wish I could attach my table.

 

[SpillerBD]

IF the filters don't change he value but only where it is in the Pivot Table display, the GETPIVOTDATA should retain the value.
With a reasonable understanding of the fields and filters you can generate your own GETPIVOTDATA formula, but normally when clicking on a cell in Pivot table while editing a formula will result in the GETPIVOTDATA reference and not the cell reference.

 

[Mysstownsend]

It changes both. If I change the filter to include more than one person, it changes the number of rows, so it changes the row the average is located. If I add more than one date to the filter, it changes which column the average is in.
I've tried naming the field but that just names the cell and then the cell changes but the name doesn't follow...
I'm more novice at this than I thought LOL

 

[SpillerBD]

select a cell outside your Pivot table, type "=", left click a value cell in your Pivot Table.
Do you not get a =GETPIVOTDATA([.......)
formula of some kind?

 

[SpillerBD]

See https://support.office.com/en-us/article/GETPIVOTDATA-function-8c083b99-a922-4ca0-af5e-3af55960761f?CorrelationId=eb8f7324-4523-4566-96e4-e3c1db152e14&ui=en-US&rs=en-US&ad=US
For more on GETPIVOTDATA

 

[Mysstownsend]

Feeling like an idiot. That worked perfectly. Thank you. I always make things more difficult.