Blank columns with a total are not hidden

A column with no values in it can be easily hidden natively in Knack. However, if column totals are required (which they often are) the column is no longer hidden even though it is blank and has a sum of 0.

It would be good to extend the hiding of blank columns so that a 0 total is also ignored and hidden.

If I turn off the column totals, your suggestion works. But I need the column totals for every column that doesn't have a 0 total. So I currently have to choose between having no totals (which isn't great) and 50 columns with 0 totals (which is only marginally better).

Tha's actually how I have the table and columns set up. It doesn't show the 0 values in the column, but still shows the 0 for the total. Which is the problem I was describing - if there is no values in the column, then (at least in this case) it's pointless to have the 0 total show.

What about using a display rule on the column that hides the value of = 0 then set the table to hide empty columns.
This works as I have used this method.

I have columns hiding values and the table set up to hide blank columns, but if a Total is selected for the column it still doesn’t hide the column…I think this is because the total of $0.00 still appears and therefore it doesn’t think it’s empty. Is there any way to hide a column with blank values if totals are turned on for columns?