I have created a sample application on your data , please have a look once and let me know what is your use case ,If you tell me what you want in Excel sheet so I can reflect it here on Sense.
Sample.qvf 192.0 K
I am trying to build a straight table in the form
Same Ticker Match
TICKER Buy Client Sell Client Buy Quantity Sell Quantity Sector
Diff Ticker Match
Buy Ticker Sell Ticker Buy Client Sell Client Buy Quantity Sell Quantity Buy Sector
then need to have a single filter for either legs of the match. For example, choosing CLIENT_1 should filter the table and show all records where CLIENT_1 appears on either side of the match essentially the answer to the question give me all the matches involving CLIENT_1.