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



Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!