For 1st Pivot, in the Row Labels, I require Call Summary (T) and Counterparty Name (E) and in Value, a count of Agreement (F)
From the dropdown of Call Summary, "OK" and Blanks should be excluded.

Other pivots have the same logic except that the column changes.

Thanks for looking into this.