Table Transformer: Average calculation excluding empty cells

Hello,

I have a table like the following.
I used Table Transformer on top of a Pivot Table to calculate the "​Avg​" Column.

SELECT *,
('Tot' / 5) -> toFixed(0) AS 'Avg',
FROM T1

Questions:

1. Feature Proposal​: In Pivot Table --> Options there is "Hide Totals". It would be great to have split in 2: "​Hide Totals Row​" and "​Hide Totals Column​". I would like in fact to show only the Total in Column.
2. Question​: Is there a way in Table Transformer to hide the last row, or the row with a certain label ("Total")? I would like a solution in Table Transformer, not Table Filter or Table Excerpt.

1. Question​: In the SQL statements, is it possible to identify a column without specifying its name? Like #C2 instead of 'Sn3'?
2. Question​: In line R5 there are 2 empty cells. The 'Avg' column is sum of columns 'Sn<x>' / 5. But for R5 I should calculate 'Sn<x>' / 3 as there are 2 empty cells. Could you suggest a statement to achieve that?

Thanks!!!