Is there any way to set up a filter on pokertracker that will only show me the hands where I am all in preflop against an opponent when I have a bigger pair then him/her (i.e. - I am all in with QQ and he/she has 99). I want to see if I get screwed as much as my brain thinks I do.

I have already figured out how to filter my hand, but not filter what my all in opponent has.

You can't do that in a report in the main PT3 window, you'd need to do it as a custom report.

Add the following two filters to a custom report to see only hands where AA and KK were shown down:


holdem_hand_player_statistics.id_hand in (SELECT holdem_hand_player_statistics.id_hand from holdem_hand_player_statistics WHERE holdem_hand_player_statistics.id_holecard = 1)
and
holdem_hand_player_statistics.id_hand in (SELECT holdem_hand_player_statistics.id_hand from holdem_hand_player_statistics WHERE holdem_hand_player_statistics.id_holecard = 26)

(QQ is id_holecard 49, JJ is 70, TT is 89, 99 is 106, 88 is 121, 77 is 134, 66 is 145, 55 is 154, 44 is 161, 33 is 166, 22 is 169)