Greetings all,

I have the following Pivot Table for budget information:
pt question.PNG

The purple table on the far right is not part of the Pivot Table, but I want it to adjust based on the pivot table.

I have the main filter - OWN DESC that I will use to create multiple versions of this pivot table for each owner. Once each Owner has its own tab, I need the purple table to align appropriately on the correct function and object codes.

So in the example picture, I would want a formula to return the function on the same row and another to return the object code. Like this:
pt question 2.PNG

I don't want to have all of the labels on for the whole Pivot Table...and I'm pretty sure somehow this can be done...but I'm just not sure how. Probably by ignoring that it is a PT at all and instead relying on cell references...

Any suggestions would be greatly appreciated.