Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.
That isn't possible - the Session report only shows information about overall session results, and non-showdown results aren't stored for whole sessions. See "Sessions" in the Tutorial: Custom Reports and Statistics.
You could use my "HCPS Session Stats" custom report, which is available from the "Get More" section, and use a filter for NOT(Went to Showdown) when you display the Amount Won stat. Tutorial: Filters
It would work if theres sessions by time(not table)
what I want is too see how many hours I played per session(by time) and how much did I win in NON-SD AND I dont want to see my total winnings. is that simple thing possible?
Honestly I think the easiest way to do this would be to load Sessions (by time), and pop the window out via the four arrows icon at the right.
Then add a filter for not(went to showdown) and change to the Hands tab, look at the total winnings in the top report, compare with the hours popped out.