I don't think it is possible to filter like that using the general filters. It may be possible in a custom report but I'll have to investigate when I have a little more time.
Using this custom filter in the blue Filters link will get you all hands that went to showdown that included a player of the color whose number you put in for X. The numbers are 1 through 8 in the order you see them in your screenshot (1 = yellow, 2 = green, 3 = cyan, etc).
cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, player p, notes n where p.id_player = chps.id_player and chps.flg_showdown and n.id_x = p.id_player and n.enum_type = 'P' and n.id_color = X)
It would be perfect if you could name and save these so you could quickly access filters for showdowns vs different types of villains. For instance, I tag shortstackers purple and regs orange. Our strategy is different vs each of these player types (and vs others) so filtering for this is very useful.
edit: oh wait, you can by just saving them as a custom report. sweet!
This filter will give you hands played against Player X.
( 0 < (SELECT count(hhps2.id_hand) FROM cash_hand_player_statistics hhps2 WHERE hhps2.id_hand = cash_hand_player_statistics.id_hand AND hhps2.id_player = (SELECT p.id_player FROM player p WHERE player_name='Player X')) )
Can you be so kind and give me the filter that you posted including nonshowdown winnings? I tried removing 'chps.flg_showdown' but that will include winnings vs other players that don't have the notes on them :/.
To make it include only hands that didn't go to showdown instead you use: cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, player p, notes n where p.id_player = chps.id_player and not(chps.flg_showdown) and n.id_x = p.id_player and n.enum_type = 'P' and n.id_color = X)