Hi , add a 'current selections' box to your dashboard . Then click anywhere in your straight table. You will notice that all the DIMENSION values in the row that you selected are added to current selections....but not any of the expressions (in your case Sales). So this will not work.
So ...what exactly do you want to occur when selecting a row in the straight table ? Perhaps there is an alternative.
in answer to your 2nd question, you can check 'Read only' on the straight Table chart properties (general tab). Then no click will apply a filter.
At that point, you could also overlay a 100% transparent text box over the chart and assign an action to the text box. Technically its possible to size a few list boxes in this way (1 over each field) to do something (like set a varaible and show a chart or a sheet)
But what exactly is the column filter you want to pass ? a range of expression values ? set of dimension values ? i'm not clear.
.png "Former Employee"){kind=icon}