Pivot Table Reference ( getpivottable)

Hi,

Is there any way a pivot table value can still be traced with the getpivottable function when the field is not available in the pivotdisplay ?

See the retional lookup works when the field is displayed, but not if the field is not displayed. see cell a36 and f36

See the enclosed sheet

Greetings,

Jack:spin:

It did not take the Attachment, see message about getpivottable formula

Jack