Pivot2 is just a copy of Pivot1. All I did was move Investigator from the Row Labels in the pivot options on Pivot1 to the Report Filter. Other than that, they are identical. Go ahead and delete Pivot2. I just added it as an illustration of the flexibility of pivot tables. No need t muddy the waters further with it. There's probably something about Investigator being in the filter that is throwing a wrench in things.

Truthfully, your priority should be to get the Data and Log tabs to your suiting first. Then I suggest deleting both pivots and starting fresh.