Can I pull Unique IDs from a PivotTable using GETPIVOTDATA?

[oddzac]

For NDA reasons, I can't fully disclose details of the project I'm working on (re: large amounts of personal and confidential info) and I apologize in advance if this makes answering my question harder.

I'm generating a report based on a weeks worth of productivity metrics. These metrics are imported via queries to individual sheets in the woorkbook and then pivoted to extract and compile data.

My challenge, currently, is one of design simplification rather than utility.
Each employee has a unique "Login" that I use to reference the rest of the metrics in a table on the main sheet.
These logins are pulled from one of the queried reports, pivoted, and only populate if they exist in that report.
The trouble I'm having is that I've built the main table to reference that pivot with:

=WSSW!AC4

-

=WSSW!AC304

with a wide gap of blank references to ensure that the entire pivot is captured.
Because of this, I have a huge (useless) chunk at the bottom of my sheet that bugs the mess outta me

(continued for about 100 lines)
And I have to actively cut that space out of my table each time I run the report.


SO, I'm looking for a way to get the rows of my table to adjust/autofill based on the number of populated logins.
Something tells me GETPIVOTDATA is the answer, but I haven't been able to get it down when the table only has the "row labels" initial column..

Am I asking for too much?

 

[oddzac]

For better context, this is the pivot I'm pulling from... redacted.

 

[oddzac]

If I knew how to edit a post, believe me, I would

This is the Table info for the pivot above:

 

[Peter_SSs]

If I knew how to edit a post,

You can edit your post by clicking the 'Edit' link at the bottom left of the post. However, that link only appears for 10 minutes after you make the post.