To vote on the idea, please sign in with your personal or social account (Google).
To watch the idea, please sign in with your personal or social account (Google).
I have a table like the following.
I used Table Transformer on top of a Pivot Table to calculate the "Avg" Column.
('Tot' / 5) -> toFixed(0) AS 'Avg',
- 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.
- 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.
- Question: In the SQL statements, is it possible to identify a column without specifying its name? Like #C2 instead of 'Sn3'?
- 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?